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

Eshwar Nakkala 106 Reputation points
2021-01-20T10:28:11.653+00:00

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

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,996 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.