在其他服务器中查找表 [英] Locating table in other server

问题描述

是否可以从其他数据服务器找到表?

Hi,

Is it possible to locate a table from other data server?

Instance   database name       table name
server1    dbWin               grGroup1

server2    dbCon               grGroup1

grGroup1和grGroup2具有相同的表结构，但是grGroup1的记录将来自另一个数据库服务器中的grGroup2.

grGroup1 and grGroup2 has the same table structures but, grGroup1''s records will be coming from grGroup2 which is located in another database server.

If its possible, How will i do this?

推荐答案

您需要添加链接服务器，然后尝试
要添加链接服务器，请通过以下链接

http://msdn.microsoft.com/en-us/library/aa560998 (v = bts.10).aspx [

You need to add link server then try
To add link server please go through the below link

http://msdn.microsoft.com/en-us/library/aa560998(v=bts.10).aspx[^]

这篇关于在其他服务器中查找表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！