Hi,
I am new to Azure. May I know what is the best way to copy data from a Azure SQL DB to another Azure SQL DB on schedule job?
Will be good to give me some guides. Thank you very much.
Hi,
I am new to Azure. May I know what is the best way to copy data from a Azure SQL DB to another Azure SQL DB on schedule job?
Will be good to give me some guides. Thank you very much.
Hi @GohSokBoon-9189, welcome to Microsoft Q&A forum.
As I understand you want to set up schedule/automate sync between two Azure SQL Databases.
For this purpose we can set up SQL Data Sync which would sync these databases. Please read more on that below:
What is SQL Data Sync for Azure?
Its fairly simple and straight forward process which is explained step by step in below article. However please let us know if you have any queries:
Tutorial: Set up SQL Data Sync between databases in Azure SQL Database and SQL Server
For the scheduling part, we can refer to below screenshot:
Please let us know if this helps or else we can discuss further on the same.
If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!
Hi AnuragSharma-MSFT,
Thank you for your reply. Actually I want to do copy some table data to another table in Azure SQL and do some transformation. Not really a direct sync between 2 DB.
Thanks for replying back @GohSokBoon-9189 and providing more details.
If data transformation is involved, we can use Azure Data factory. It can take first Azure SQL DB as source and then apply transformation on the data and then insert/update the records on the sink which is our 2nd Azure SQL Database. One basic example of transformation is mentioned in below link with derived column but there are lots of transformation available based on our requirements:
Derived column transformation in mapping data flow
To read more about ADF please refer to below article:
Copy and transform data in Azure SQL Database by using Azure Data Factory or Azure Synapse Analytics
Please let us know if this helps.
3 people are following this question.