4

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.

Improve this question
2
  • 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. Commented Jun 9, 2017 at 5:29
  • Note worthy. SQL Replication to Azure is now generally available. azure.microsoft.com/sv-se/blog/… Commented Mar 5, 2018 at 10:33

1 Answer 1

Reset to default
5

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
1
  • 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. Commented Jan 30, 2017 at 22:14

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.