Copy table data from Azure SQL Database to another Azure SQL Database?

Question

I have to copy table data from one Azure SQL Database to another Azure SQL Database which are under same Azure server.

Is there any way to do this using Azure data factory? Also, this needs to be scheduled as a daily feed.

Edit : How can we add more tables to the existing dataset ? I have created this for 3 tables, now i want to add two more tables to this, how ?

Answer 1

Did you have a look at Copy data to and from SQL Server by using Azure Data Factory?.

In Azure Data Factory, you can use the Copy activity to copy data among data stores located on-premises and in the cloud. After you copy the data, you can use other activities to further transform and analyze it

You can have a look at the steps from here on how to configured a triggered pipeline.

One important thing to remember is that you'll have to define the data set (with or without schema) for all tables that require copy for any source-destination combination.