Menu
Is there any way to migrate Azure SQL server/database from one geographical region to another region? Thanks.
806
Create a new SQL Server in the region of your choosing. Add your service (s) IP addresses to the new SQL Server firewall. Stop writes to the origin database. Open the origin database in the Azure Portal and click Copy at the top of the blade. Choose your new SQL server located in the destination region. Wait for the copy to complete.
Migrate your data to Azure from the most common database management systems. Whether you’re moving from an on-premises database or another cloud, Database Migration Service supports key migration scenarios such as SQL Server, MySQL, PostgreSQL, MongoDB, and Oracle. Save time and effort by automating your move to Azure with PowerShell.
Azure Database Migration Service is designed as a seamless, end-to-end solution for moving on-premises SQL Server databases to the cloud. Use the Database Migration Guide for recommendations, step-by-step guidance, and expert tips on your specific database migration.
The functionality currently does not exist to move your Azure SQL Data Warehouse instance to a subscription other than the one it was created under. What you can do is move the server that contains the instance to another subscription or resource group. Moving a server will move all Databases owned by that server to the destination subscription.
You can use Geo-replication to create a replica of your actual databases on the new desired region, then you can failover all of them making databases on the new region the primary databases, now you can drop all secondary databases on the old original region. You can learn about setting up Geo-replication using Azure portal here.
Another option is to copy the databases to a server located on the desired region using the Copy Database feature as explained here.
A third option is exporting the database to a blob storage as bacpac then import it to a SQL Azure server on the new region as explained here.
Finally, you can also use SQL Data Sync (as explained here) to copy databases to the new region on a new server, and keep the servers synchronized, then you can remove databases from the sync groups, remove SQL Data Sync and drop the original databases.
Hope this helps.
174
The official Azure documentation about moving SQL resources across regions.
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
