How to perofrme copy table data from one databse to another database in azure cloud

Eshwar Nakkala 106

Hi,

I am Eshwar,

I have azure account and have created 2 different databases ex: db1 -table tb1 having column's cl,c2,c3 , db2 -table tb2 having column's cl,c2 and I have a requirement to create one more table with the db1 -table tb1 having column's c3 and db2 -table tb2 having column's cl,c2

can anyone help me on the above requirement how to achieve it in cloud insteadof elastic query concept please....

Regards,

eshwar

JamesTran-MSFT 36,541 Reputation points Microsoft Employee

2021-01-20T21:36:54.22+00:00

@Eshwar Nakkala
Thank you for the post!

I was able to find some articles that might help with your issue, I'll post them below. I've also engaged our database team to assist on this issue, in the meantime would you be able to provide some more details (i.e. what type of database is this) so we can gain a better understanding of your issue?

Azure: Copy data from one database to another using Azure Data Factory – II
Copy one table data to another database table in same server Azure Services
Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-01-23T00:19:29.38+00:00

@Eshwar Nakkala

Please let us know if you need any further help.

Regards
Navtej S
Eshwar Nakkala 106 Reputation points

2021-01-25T11:01:21.87+00:00

Thank you for your response!!

I am using Microsoft sql server 18.5 version I am using

1 answer

Alberto Morillo 33,426 Reputation points MVP

2021-01-20T22:32:34.17+00:00

You can use elastic queries, to make cross database queries, and bring data from other Azure SQL databases to a specfic database. You can see the steps needed on this tutorial.

Alternatively, you can create a view on the source database with the columns and rows from the table that you want to copy, and use Azure Data Factory to copy the data on the view to the destination database as explained here.

Hope this helps.
Please sign in to rate this answer.
Eshwar Nakkala 106 Reputation points

2021-01-21T05:44:59.493+00:00

Thanks for the response Albert

For my requirement [I have azure account and have created 2 different databases ex: db1 -table tb1 having column's cl,c2,c3 , db2 -table tb2 having column's cl,c2 and I have a requirement to create one more table with the db1 -table tb1 having column's c3 and db2 -table tb2 having column's cl,c2]
this is not working.

The same is working in elastic Query but I need another way to achieve this requirement.

Kindly suggest me the solution please ,

Alberto Morillo 33,426 Reputation points MVP

2021-01-21T19:09:17.593+00:00

Hi Eshwar!
Do you mean that the copy process is not working with Azure Data Factory?

If it is working with elastic query, why not using SELECT C1, C2 INTO ResultTable FROM ExternalTableCreatedByElasticQuery as the tutorial I shared to you is explaining?
https://intelequia.com/blog/post/735/query-and-transfer-data-between-azure-sql-databases

Regards,
Alberto
Sign in to comment

Share via

How to perofrme copy table data from one databse to another database in azure cloud

1 answer