F6 Team

今天聽到同事在講DBLink的東西,去找了一下資料

其實DBLink就是將不同的DB Server建立連結起來..

可以下Query Sql語法連結不同的DB Server..

小弟以兩台 MS SQL Server 2005 來測試
 

--Add DB Link Server EXEC sp_addlinkedserver @server = 'F6', --Server Name @srvproduct = 'MS SQL', @datasrc = '192.168.1.1' , --Server IP @provider = 'SQLNCLI' --Remove DB Link Server EXEC sp_dropserver @server = 'F6' --Server Name --Add Login User and Password EXEC sp_addlinkedsrvlogin @rmtsrvname = 'F6' , --Server Name @useself = 'false' , @locallogin = NULL , @rmtuser = 'sa' , --User @rmtpassword = 'sasa' --Password

--Query DB Link Server select * from sys.servers

--Query Login User select * from sys.linked_logins

--Query DB Link Data select * from [F6].[database].[dbo].[table] --select * from [server name].[database name].[owner name].[table name]

參考網址:

http://space.itpub.net/12184684/viewspace-504542
http://www.cnblogs.com/aierong/archive/2005/03/16/119696.html
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
http://msdn.microsoft.com/en-us/library/aa259589(SQL.80).aspx
http://tsuozoe.pixnet.net/blog/post/22417837
http://database.ittoolbox.com/groups/technical-functional/sql-server-l/connecting-to-different-sql-server-t-sql-52929