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.

  • Forgot my question.. I haven't found a good answer to this one yet. We went with the manual approach: Took it offline, created a bacpac file, uploaded it to azure storage, and restored from that one. – Andreas Jun 9 '17 at 5:29
  • Note worthy. SQL Replication to Azure is now generally available. azure.microsoft.com/sv-se/blog/… – Andreas Mar 5 '18 at 10:33

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

| improve this answer | |
  • Since this have nothing to do with Azure database service. This won't help me at all. I have updated the question a bit to make it more clear of what I am looking for. – Andreas Jan 30 '17 at 22:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.