3

We are migrating database from Rackspace to Azure. Our databases were deployed on Virtual Machines in rackspace. In our queries we are using Linked server to other databases. Basically cross database query. problem is that after migrating databases, we are unable to use linked server queries as Sql Azure db does not supports Linked Servers.

Kindly help.

UPDATE:

  • Not all databases are in azure. Some databases are with their respective owners in remote locations. We need to query database that are running outside Azure.

  • There's no VM for Sql Server in Azure. We are using Database as a service in Azure.

See the image below for more details

enter image description here

1

While not ideal, an alternative approach here could be to setup your Azure database as a subscriber to replication publications created from your on-premise database(s). Replication will allow you to limit the articles within the publication, filter the types of records, etc. which hopefully means you can minimize the publications to only send the data necessary to serve the traditional four-part queries. If you still want to utilize cross-database queries, you can always create a second Azure DB which would act as the subscriber to these publications and then utilize cross-database queries from your current Azure DB which may allow you to minimize any rewrites of existing functionality.

  • See update..... – Amit Ranjan Jul 26 '17 at 7:13
  • @AmitRanjan Are you unable to setup publications for the databases in the Unknown Cloud SAP denoted on your diagram? – John Eisbrener Jul 26 '17 at 13:53
  • We are not allowed to touch/change/modify objects in Database1/2/3. We can only query tables using Sql Linked Server – Amit Ranjan Jul 27 '17 at 4:06
  • 1
    @AmitRanjan At this point, it may be safer to migrate to Azure VMs instead of Azure SQL DB. This offers similar licensing costs, but should allow you to make that call over a LinkedServer. Hopefully someone else comes up with a better approach. – John Eisbrener Jul 27 '17 at 18:00
0

You can use cross database queries as explained here.

Hope this helps.

Regards,

Alberto Morillo

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.