开发者

Query two different Servers

I have to query two different servers from a dynamically built query.

It basically gets data from one server, treats it, and inserts it into another server.

The only problem is I have to be sur开发者_如何学Pythone it works for both situations: If both the source and destination databases are on the same server, and if they're not.

I understand the concept of using Linked Servers in SQL Server, but I cannot think of a way to consider both alternatives, same server and different servers.

A little help?


Two linked servers are not necessary... just one per server. Example

PhysicalServerA
   SQLServerA
      DatabaseA
      DatabaseB
   LinkedSQLServerB  // A linked server to SQL Server B

PhysicalServerB
   SQLServerB
      DatabaseC
      DatabaseD
   LinkedSQLServerA  // A linked Server to SQL Server A

Now Server A can have queries to itself like:

SELECT * FROM SQLServerA.DatabaseA.dbo.TableName

And queries to LinkedSQLServerB like

SELECT * FROM SQLServerB.DatabaseC.dbo.TableName

Now Server B can have queries to itself like:

SELECT * FROM SQLServerB.DatabaseC.dbo.TableName

And queries to LinkedSQLServerA like

SELECT * FROM SQLServerA.DatabaseA.dbo.TableName


Use a fully qualified table name for both tables (local and remote)

SELECT * FROM SERVER.DATABASE.SCHEMA.TABLE

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜