Data copy from Azure SQL database to another Azure SQL database

Goh, Sok Boon 46 Reputation points
2022-04-28T01:40:47.993+00:00

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
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,571 Reputation points
    2022-04-29T05:31:36.463+00:00

    Hi @Goh, Sok Boon , 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!