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.

Andreas
  • 299
  • 1
  • 5
  • 15
  • 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 09 '17 at 05:29
  • Note worthy. SQL Replication to Azure is now generally available. https://azure.microsoft.com/sv-se/blog/transactional-replication-to-azure-sql-database-is-now-generally-available/ – Andreas Mar 05 '18 at 10:33

1 Answers1

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.

Mr. Raspberry
  • 3,878
  • 12
  • 32
  • 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