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.