I am in the process of migrating our client's database to the Azure Cloud SQL Server and setting up data sync etc. All of this is ok, but I need to reduce the amount of time the client's system needs to be down for to complete this process.
I was hoping to be able to set up a process that records all database inserts/updates from the time I create the backup which will be used in to migrate the data to azure, and then replay them on the database once it's in the cloud.
Is there a tool for this? Is SQL Profiler good enough for this?
Best Answer
Just to close this off, I found that Red gate Data Compare seems to be a great tool that will allow me to simply compare the two databases and in essence replicate the differences.