Home / server / Questions / 829257
In Process
Andreas
Asked: 2017-01-30 03:19:18 +0800 CST

Migrate SQL 2008 database to Azure

  • 772

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud.

Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just switch over to just using the new one. Instead of take it offline, create a bacpac file, upload it to azure storage, and restore from that one.

I want to do this to reduce downtime during the migration.

Azure doesn't support the traditional log-shipping, and This require that you are moving from a 2012 database or newer.

Edit: Made the question much clearer.

sql-server-2008 replication azure-sql log-shipping

1 Answers

  1. Since you need to migrate SQL 2008 to a new host, I would suggest you follow the blog post instructions. That works for me.

    • 5