Migrate SQL 2008 database to Azure RRS feed

  • Question

  • 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, and keep it up to date? 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.

    Regards Andreas Marshall

    Tuesday, January 31, 2017 12:30 PM

All replies