1

I have installed Sql Server 2012 on my virtual machine. I am looking to migrate SQL Server database to Azure database. I have three database. In that I have multiple table. Suppose I have Database1.table1 ... ,Database2.table1 ... ,Database3.table1 .... and in that I have some tables and stored procedures which use cross db queries to get result.

When I try to migrate to Azure database I found that it does not support Cross query. To achieve this I need give the external table reference in parent table. I followed these links

https://sqldusty.com/2017/05/30/setting-up-cross-database-queries-in-azure-sql-database/

https://www.c-sharpcorner.com/article/cross-database-queries-in-azure-sql/

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-getting-started-vertical

Here I want to know that,

Is it store same data in parent as well as in external referenced table?

and

How does it affects on performance?(Means I have millions of records in db2.table1 and I am joining db1.table1 on primary key column with where clause.)

Improve this question
5
  • 1
    Have you considered hosting them in the same database but different schemes? Manages Instance is now in preview and it supports cross-database queries so you could look at that. Commented Apr 23, 2018 at 16:46
  • I too would go with managed instances ,if you need more on premises like experience' Commented Apr 23, 2018 at 17:22
  • @wBob thanks for reply. Yeah I have hosted in same Database but with different schema name Commented Apr 24, 2018 at 4:40
  • @TheGameiswar Will go through the documentation. Thanks Commented Apr 24, 2018 at 4:41
  • @TheGameiswar I chacked Managed instances and decided to go to Azure Sql database instead. I have one question can you please check this stackoverflow.com/questions/50289411/…? Commented May 11, 2018 at 10:01
Related questions
0
SQL Azure - cross-database queries
0
Azure SQL Performance
2
Azure SQL query slow
Load 7 more related questions Show fewer related questions

0

Reset to default

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.