Currently cross database joins are not supported in SQL Azure. Also you cannot change database mid query so you cannot, for example, put a USE [MyDB] in your query either. As a side note, please vote for it to be a priority feature for the SQL Azure team to develop soon.
So, since cross database joins are not supported at this time you must find a workaround. I will give you two possible solutions I would recommend and you can hopefully choose the one that is best for your application.
Combine your databases
If you have tables that are frequently used together, i.e. they are joined in queries or the rows are inserted in the same transactions, then it would be a good idea to move the similar tables into the same database. This of course eliminates the need to traverse databases. SQL Azure has very recently increased the maximum database size from 50GB to 150GB, which potentially makes this a more viable option than perhaps it once was.
Join your data in your application
Two separate queries could be run on the two separate databases and then these results could be joined within that application. Obvious downsides to this will be the potential for large DB I/O, large network transfer and large memory usage in your app. This is not something to consider if the amount of data that is likely to be returned is large (e.g. 1000+ rows) but it is fine if the data will be manageable.
Conclusion
Personally I would much rather settle for bringing all my similar tables that are likely to be used within the same queries together into one database so there is no longer a need for cross database solutions. This makes for cleaner application code and more efficient use of your resources. However, if this option is not available to you then perhaps the second option may have to be the one you choose.
Surely soon in the future the SQL Azure team will address this issue though and your cross database code can stay clean! Although in fairness cross database querying isn't even available in Entity Framework yet (but still workaround-able) either. I wonder why this is so difficult for Microsoft? Just shows you should always try and combine similar DBs in any database designs where possible.
I am very glad to know a lot from you this meaningful.your weight loss is rich with a lot of useful and helpful information.
ReplyDeletecustom essay
Did you just realise you have an assignment pending for the submission in two days? You need not worry! Just place an urgent order at Law Writers UK. You don’t need to ask anyone can you do my assignment urgent, when we’re just one tap away. Whether your assignment is due for submission in a few days or a few hours, we can handle the burden by meeting the deadline. We are well-known for providing high-quality content and employing a team of excellent writers with a proven track record. With our 24/7 online support, you can track your order to stay updated about the progress.
ReplyDeleteAlso See: How To Write Dissertation
I am very glad to know a lot from you this meaningful.your weight loss is rich with a lot of useful and helpful information. دانلود آهنگ های ایرانی
ReplyDeleteBlackbird packaging provide you with any size, shape design, lipstick boxes sooner than any other packaging competitor in the market
ReplyDeleteBlackbird packaging provide you with any size, shape design, custom cbd boxes sooner than any other packaging competitor in the market
ReplyDeletePacakaging town is a one stop solution for the short-run cbd facial oil boxes, needs and supplies. At affordable prices. Request a free quote now.
ReplyDeletePackaging town is a one stop solution for the short-run tincture packaging needs and supplies. At affordable prices. Request a free quote now.
ReplyDeleteBuy custom vape boxes online from blackbird packaging at best prices. get free shipping.
ReplyDeletebuy cbd vape cartridge packaging online from blackbird packaging at best prices. Get Free shipping
ReplyDeletebuy lahore grocery from alfatah at best prices. Get free shipping
ReplyDeletebuy grocery online in lahore from alfatah at best prices. Get free shipping
ReplyDeleteA good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one. it's time to avail this Air Duct Cleaning Services Lakewood visit here for more details.
ReplyDeleteI recently found many useful information in your website especially this blog page. Among the lots of comments on your articles. Thanks for sharing. it's time to avail this garage door repair kennesaw visit here for more info.
ReplyDeleteLogo Design Dubai Company having experts in logo designing who providing the best quality services of logos like brand, creative, graphic design at affordable cheap logo design service by creative and professional graphic designers in 24 hours.
ReplyDeletebuy galaxy leggings online shopping from dshred at best prices deliered at your doorstep. Get free shipping
ReplyDeleteBuy the latest Lawn Collection from Reign and enjoy the best price with free home delivery.
ReplyDeleteBuy electronics online in Pakistan from alfatah at best prices delivered at your doorstep. Get free Shipping
ReplyDeleteBuy jogger pants men from ndure at best prices delivered at your doorstep. Get free shipping
ReplyDeleteBuy gym trousers for men online dshred at best prices delivered at your doorstep. Get free shipping
ReplyDeleteBuy gym trousers for men online from dshred at best prices delivered at your doorstep. Get free shipping
ReplyDeleteWe do extra care of your babies. Buy best quality baby care products online in Pakistan from medisense. Order Now and get fast delivery.
ReplyDeleteBuy best quality hair care supplements in Pakistan at best prices from medisense. Order Now and get fast delivery at your doorstep.
ReplyDeleteBuy quality citizen ch 453 bp monitor price in Pakistan online from medisense. Get fast delivery.
ReplyDeleteBuy Mens t-shirt online from Ndure at best prices delivered at your doorstep. Get free shipping.
ReplyDeleteBuy men clothing online in Pakistan at best prices delivered at your doorstep. Get free shipping.
ReplyDeletebuy grocery online in Pakistan at best prices delivered at your doorstep. Get free shipping.
ReplyDeleteYou share informative post related to cross database and SQL azure in detail. This post is vey helpful for computer students. Further, This time to take advantages of Bail bonds agent in Dallas TX for best progress.
ReplyDeleteNDURE brings you its wide range of polo t shirts for men online in pakistan. Now you can buy your favorites with just a tap You can find our t shirts online by logging into our site Our shirts are made with pure fabric that makes you stand out So don t wait around and shop from our collection of online t shirts.
ReplyDeleteIt was very good and informative
ReplyDeleteپازل بند