4

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 ?

Improve this question
0

2 Answers 2

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

Link only answers do attract downvotes. Someone with 158K reputation should know they need to quote the relevant parts from the site and then cite the resource. That makes the answer useful to future readers should the link become dead.
It's not not link only answer. don't you see the 2nd sentence?
I see the second sentence, but that doesn't include the relevant parts of the link. From How do I write a good answer?: "Links to external resources are encouraged, but please add context around the link so your fellow users will have some idea what it is and why it’s there. Always quote the most relevant part of an important link, in case the target site is unreachable or goes permanently offline." You don't do that. Answers like that do attract downvotes, like I said on my comment. There's even a review queue to delete such answers.
Adding two cents - since you are going to be performing this activity daily so yout might want to copy data incrementally so your pipelines are effective. learn.microsoft.com/en-us/azure/data-factory/…
Message=Violation of PRIMARY KEY constraint 'PK__tbl__****'. Cannot insert duplicate key in object 'dbo.*****'. The duplicate key value is (103). The statement has been terminated.,Source=.Net SqlClient Data Provider,SqlErrorNumber=2627,Class=14,ErrorCode=-2146232060,State=1,Errors=[{Class=14,Number=2627,State=1,Message=Violation of PRIMARY KEY constraint 'PK__tbl__****'. Cannot insert duplicate key in object 'dbo.*****'. The duplicate key value is (103).,},{Class=0,Number=3621,State=0,Message=The statement has been terminated.,},],'
1

you can think of elastic queries(preview)-for cross database queries and elastic jobs (preview) for job scheduling.

  1. Utilize Elastic query for bringing result from another database on the same server. Read more on Elastic Query. The advantage is it is coming as free with Azure SQL.

Elastic database query (preview) for Azure SQL Database allows you to run T-SQL queries that span multiple databases using a single connection point.

  1. Schedule Elastic job(currently in preview) which can be used to schedule job in a Azure SQL database. Read more on Elastic jobs

Elastic Database Jobs (preview) are Job Scheduling services that execute custom jobs on one or many Azure SQL Databases.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.