用SQL连接数据库 [英] Connecting Database in SQL

问题描述

我想连接两个数据库.

我的主要目标是将数据从SQL Server 2000的视图表中获取到我的SQL Server 2005的中央数据库中.我的主要要求是数据获取应该是实时的.

Hi, i want to Connect two database.

My Major aim is to fetch data from the view table in SQL server 2000 to my central database in SQL server 2005. my major requirement is that the data fetching should be in realtime.

Can any one help in that ???

推荐答案

可以看到下面的链接，它将逐步向您展示数据传输的方法.
http://www.aspfree.com/c/a/MS-SQL-Server/SQL-2000-Data-Transfer-is-a-Snap-with-SQL-2005/ [

See the link below, it will show you step by step way to transfer data.
http://www.aspfree.com/c/a/MS-SQL-Server/SQL-2000-Data-Transfer-is-a-Snap-with-SQL-2005/[^]

尝试使用链接服务器.

可以在此处找到文档. /en-us/library/ms190479.aspx"target =" _ blank"title ="新窗口> ^ ]

建立链接服务器后，可以像这样调用视图，

Try using Linked servers.

Documentation can be found here[^]

After you have established a linked server, you can call your view like this,

SELECT       
    tb.id,
    tb.column1,
    tb2.column1,
    tb2.column2
FROM dbo.Table2 tb2
INNER JOIN  Server2.Database2.dbo.Table1 tb
ON tb2 = tb.id

这篇关于用SQL连接数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！