question

GohSokBoon-9189 avatar image
0 Votes"
GohSokBoon-9189 asked GohSokBoon-9189 commented

Data copy from Azure SQL database to another Azure SQL database

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.

azure-sql-database
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered GohSokBoon-9189 commented

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:

197631-image.png

Please let us know if this helps or else we can discuss further on the same.

If answer is helpful please click on 197641-image.png 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!




image.png (34.4 KiB)
image.png (5.7 KiB)
· 3
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GohSokBoon-9189 avatar image GohSokBoon-9189 ·

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.

0 Votes 0 ·
AnuragSharma-MSFT avatar image AnuragSharma-MSFT GohSokBoon-9189 ·

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.

1 Vote 1 ·
GohSokBoon-9189 avatar image GohSokBoon-9189 AnuragSharma-MSFT ·

Thank you. I will take a look.

0 Votes 0 ·