Replication and Elastic Query.

Shubhanshu Dubey 21 Reputation points
2021-01-20T09:57:13.317+00:00

By using some way other than the Elastic Query.

I'm having 2 cloud databases(db1 and db2) with table-t1 in db1 and table-t2 in db2. i need to get the particular columns of both the tables t1 and t2 to some other table which may reside in db1 or db2 or anywhere else, without using the Elastic Query

db1 - t1

col1 col2 col3

db2 - t2

col1 col123 col33 col12 col43

Result-

external table

col2 col3 col33 col12

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,576 Reputation points
    2021-01-20T10:36:09.673+00:00

    Hi @Shubhanshu Dubey , welcome to Microsoft Q&A forum.

    To query multiple azure sql databases, currently we have to use elastic queries or external tables. If there were blob storage we were reading from we could have used openrowset function but this is not the case with your requirement I think.

    Could you please tell us if there is any restrictions to use elastic query, also and where are you going to use this data?


1 additional answer

Sort by: Most helpful
  1. Mladen Andzic - Msft 6 Reputation points Microsoft Employee
    2021-01-23T10:17:08.273+00:00

    Could you host both databases in a single Azure SQL Managed Instance?
    If yes, you could do native cross-db querying just like in the SQL Server, using 3-part names of the objects (tables).
    Also, if for isolation reasons those two databases would reside on different managed instances, you could still use linked server functionality.

    Finally, if you need to stick with SQL Database for any reason, check whether Data Sync covers your use case.

    0 comments No comments