Skip to main content
Tweeted twitter.com/StackDBAs/status/1329303410336800775
added image for more detailed insight.
Source Link
Amit Ranjan
  • 197
  • 1
  • 2
  • 6

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

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.

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

added 6 characters in body
Source Link
Amit Ranjan
  • 197
  • 1
  • 2
  • 6

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:

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.

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.

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.
added 171 characters in body
Source Link
Amit Ranjan
  • 197
  • 1
  • 2
  • 6

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.

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.

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.

Source Link
Amit Ranjan
  • 197
  • 1
  • 2
  • 6
Loading