1
votes

Our assignment is to copy & transform data from on-premises SQL Server into Azure SQL database once in a day. We have made some tech trials and both Azure Data Factory and Data Sync are technically possible approaches for our problem.

So, what are the key decision drivers in selecting between Data Factory & Data Sync? One driver is naturally the cost. Any educated guesses on Azure Data Sync cost when it will be generally available?

1

1 Answers

1
votes

Azure Data Factory is to primarily ingest data to Azure. It can be streaming data, rdbms data, iot data etc., Whereas Synch framework is primarily for synch between your on-prem to SQL Azure. So if you have a requirement only to synch go for synch framework not with ADF