1

I have the following

Scenario: an on-premise SQL Server 2008 R2 and an app using it as db. I want to create an Azure SQL database that will be synced (asynchronous replication) with the on-premise instance. I do not want to have just a one-time migration like you can get with SQL Database Migration Wizard - (if I understand it correctly).

Goal: I need to have the on-premise instance synced, let's say via daily job that will transfer the data, with my Azure SQL database.

Is it neccessary to setup Azure Data Factory for this? What about Data Sync? I can see that it is not available on the "new portal". Any advice how to approach this in a simple way would be great. Thanks!

EDIT: So, I have looked into the case of using transactional replication as Kin suggests. However it states only versions over SQL Server 2008. Any other ideas how to cope with this? Thanks!

Improve this question

3 Answers 3

Reset to default
3

No .. Azure data factory is not required.

You can set up transactional replication from on-prem to Azure. Do not use data-sync .. its buggy and have many issues.

Improve this answer
1

The Azure SQL data synchronization tool looks like the easiest way to synchronize your databases. The feature is available to all users on the Azure portal since July 1, 2017.

Improve this answer
0

Keep in Mind that Azure Data Sync Does not accept computed columns in the tables involved in the data sync!

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.