Share via

Which Azure service is recommended to synchronize between Azure SQL databases ?

Vincent Doucet 0 Reputation points
2023-06-12T18:35:21.31+00:00

Hi everyone,

I would like to know which Azure service is recommended to migrate progressively from an old Azure SQL database to a new one ? Most of the tables are different so data transformation will be required. I've read about Azure Data Sync but it doesn't seems to support data transformation. The other option i've found is Azure Data Factory, but it seems more complex than Data Sync. It's important to mention that we have to implement a progressive solution so data synchronization is required.

Are thoses the only choices I have ?

Thanks

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,686 Reputation points MVP Volunteer Moderator
    2023-06-12T19:42:09.8466667+00:00

    Please consider using Azure Data Factory (ADF) when data needs to be continually migrated from one Azure SQL Database to another, and the data needs transformations, or needs new business logic during migration. The need for data transformations in between is what makes ADF the only option available among all Azure Services. Please see how to copy and transform data on this documentation.

    Azure SQL Data Sync does not allow data transformations.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.