azure sql data sync vs replication

Question

_{Wednesday, October 9, 2019 4:23 PM}

Hi All,

we want more information about

azure  SQL data sync vs replication

which on good, our requirement is from  on-prem  SQL server table data move to azure  SQL, based on daily refresh.

we need in one direction from source  SQL to azure  SQL.

we need to copy only few table, in feature we need more table to copy.

Data volume around 40 GB

All replies (2)

_{Thursday, October 10, 2019 2:09 PM}

Hi Manish

The Data Sync and Transactional Replication can be both used for the synchronizing of tables or DB to Azure Cloud. It will ultimately boil down to the table given in the documents already mentioned:

If you want transaction consistency and higher performance the Replication is the way forward. But if you want to bi directional movement of data you have to use the Data Sync as the Azure Single/pooled databases at this time can only be push subscribers.

Also keep in mind other limitations of DataSync:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data#sync-req-lim

Check your load against these limitations and see if it fits your data.

Please get back to us if any questions.

Thanks
Navtej S

_{Monday, October 14, 2019 3:28 PM}

Hi

The last reply has been proposed as an answer. Please mark it as an answer if this has helped you or get back to us with more questions.

Thanks
Navtej S