Azure SQL DB to Azure SQL DB replication

Question

Any one have some idea which is the best way to implement continuous Replication of some DB tables from Azure SQL DB to Azure SQL DB(PaaS) in incremental way.

I have tried Data Sync preview (schema is not loading even after couple of hours), Data Factory (Copy Data) - Fast but it is always copying entire data(duplicate records) - not an incremental way.

Please suggest.

Answer 1

I am able to achive Cloud to Cloud Migration using Data Sync Preview from Azure ASM Portal Below are the limitations

• Maximum number of sync groups any database can belong to : 5
• Characters that cannot be used in object names : The names of objects (databases, tables, columns) cannot contain the printable characters period (.), left square bracket ([) or right square bracket (]).

Supported limits on DB Dimensions

Reference: http://download.microsoft.com/download/4/E/3/4E394315-A4CB-4C59-9696-B25215A19CEF/SQL_Data_Sync_Preview.pdf