AWS Database Blog

Tag: Amazon RDS for SQL Server

Migrating an on-premises SQL Server database to Amazon RDS on VMware using SQL Server native backup and restore

Amazon Relational Database Service (Amazon RDS) on VMware delivers managed SQL Server databases in on-premises VMware environments. Managing SQL Server can be complex and time-consuming, but RDS on VMware makes it easy to provision, scale, and operate SQL Server in VMware vSphere clusters. You can migrate your existing on-premises SQL Server databases to RDS on […]

Read More

Migrating SQL Server to Amazon RDS using native backup and restore

Running Microsoft SQL Server on Amazon Relational Database Service (Amazon RDS) automates time-consuming administration tasks such as installation, disk provisioning and management, patching, minor and major version upgrades, and backup and recovery of your SQL Server databases. Amazon RDS also offers high availability using a Multi-AZ solution, replicating data synchronously across different Availability Zones. Currently, […]

Read More

Using Database Mail on Amazon RDS for SQL Server

We’re happy to announce that Amazon RDS for SQL Server now fully supports SQL Server Database Mail. Before this release, you needed to use a variety of work-arounds to enable Database Mail, such as using linked servers. With the release of Database Mail for SQL Server, you can enable Database Mail seamlessly by using database parameter groups. Database Mail is one of the heavily used features in Microsoft SQL Server. Database Mail enables you to send messages from the SQL Server to users by using a Simple Mail Transfer Protocol (SMTP) server. In this post, you learn how to configure Database Mail and send emails from an RDS for SQL Server DB instance via Amazon Simple Email Service (Amazon SES).

Read More

Migrating your SQL Server database to Amazon RDS for SQL Server using AWS DMS

This post provides a solution for migrating your on-premises SQL Server database to Amazon RDS for SQL Server using the SQL Server backup and restore method in conjunction with AWS Database Migration Service (AWS DMS) to minimize downtime. This method is useful when you have to migrate the database code objects, including views, stored procedures, and functions, as part of the database migration.

Read More

Amazon RDS for SQL Server now supports SQL Server 2019

Amazon RDS for SQL Server now supports Microsoft SQL Server 2019 for Express, Web, Standard, and Enterprise Editions. You can use SQL Server 2019 features such as Accelerated Database Recovery, Intelligent Query Processing, Intelligent Performance, Monitoring improvements, and Resumable Online Index creations. The purpose of this post is to: Summarize the new features in SQL […]

Read More

Amazon RDS for SQL Server reduces prices on Enterprise Edition in the Multi-AZ configuration

We’re pleased to announce that Amazon Relational Database Service (RDS) for SQL Server is reducing the price for both the On-Demand and Reserved DB Instances prices on Enterprise Edition Multi-AZ. The On-Demand prices have been reduced by an average by 25% across the latest generation of instance classes, which include the M5, R5, T3, X1, X1e, and Z1d. The Enterprise Edition Multi-AZ On-Demand price reduction is retroactive to July 1, 2020. The impacted Enterprise Edition Multi-AZ Reserved DB Instances purchased after August 1, 2020 will have the updated prices.

Read More

Cross-Region disaster recovery of Amazon RDS for SQL Server

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the Amazon Web Services (AWS) cloud environment. For your enterprise workloads, which depend on Amazon RDS for SQL Server, you need an effective disaster recovery (DR) strategy to help you stay up and running if an unexpected […]

Read More

Using Microsoft SQL Server Integration Services on Amazon RDS for SQL Server

You can now configure Microsoft SQL Server Integration Services (SSIS) on Amazon Relational Database Service (RDS) for SQL Server. SSIS works on Single-AZ and Multi-AZ DB instances for both Standard and Enterprise editions using either the 2016 or 2017 SQL Server major versions. Previously, you could use RDS for SQL Server as a target source […]

Read More

Configuring Microsoft SQL Server Reporting Services on Amazon RDS for SQL Server

You can now run Microsoft SQL Server Reporting Services (SSRS) directly on an Amazon Relational Database Service (RDS) for SQL Server DB instance. You can activate SSRS on Single-AZ or Multi-AZ instances on the Standard or Enterprise editions of SQL Server 2016 or 2017. If you run SSRS on Amazon Elastic Compute Cloud (Amazon EC2), […]

Read More