Azure SQL databases to Amazon RDS SQL Server DR and Migration

• By Anton Yurchenko - DevOps TL
• on 06/27/2021

We leveraged CloudBasic for RDS SQL Server Read Replicas and Disaster Recovery (DR) to deploy Azure SQL databases to Amazon RDS SQL Server Disaster Recovery, with the purpose of migrating to AWS with near real-time, after finalizing the testing of our AWS environment. CloudBasic maintained our source Azure SQL Server databases in sync with the replica databases on RDS SQL Server, over a period of a few months. Once we had our applications on AWS ready, tested against the replica databases, we performed a near-real time cut-over, promoted replica databases to primary, by performing a DR fail-over in the CloudBasic console UI. Orchestrating a fully automated fail-over, by leveraging CloudBasic’s API and other AWS services, as documented in this blog was an option for us as well: https://aws.amazon.com/blogs/database/migrating-sql-server-databases-from-microsoft-azure-to-aws-in-near-real-time-with-cloudbasic/

Initiating the jobs in the CloudBasic console UI was easy, no custom scripting was necessary. CloudBasic automatically handled any necessary database schema conversion to facilitate Azure SQL Database to Amazon RDS SQL Server replication seamlessly. It accounted for SQL Server version and edition incompatibility and created SQL Server read replicas in Amazon RDS for SQL Server, in a fully automated manner.

We reached for support to CloudBasic on https://cloudbasic.net. We had a support representative assigned, who helped us to fine tune the replication jobs, provided guidance with following up best practices to achieve near real-time fail-over.