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 No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anurag Sharma 17,606 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!


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.