Data copy from Azure SQL database to another Azure SQL database

Question

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.

Answer 1

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:

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!