Hi Team,
I have restored .bak file of AdventureWorks2012 to an on-premises SQL server.
Using Migration Assistant, I have migrated the on-premises SQL Server db to Azure SQL Server db.
Using Azure Data sync, inside a sync group I am syncing migrated azure SQL db to another Azure SQL db (on same server).
While doing the syncing, I could see out of 71 tables, data for only 33 tables inserted into new DB, for other tables it was giving errors related to limitation of Azure SQL sync.
Does this means Azure SQL data sync is not a good option for syncing data such as tables/data obtained after restoring AdventureWorks2012.bak file?
If yes, what other options I have to sync this data?
Thanks,
Salil
