整合来自不同服务器的数据 [英] Integration of data from different server
问题描述
亲爱的所有人,
我想集成来自不同服务器的数据以生成报告.
我必须集成来自位于不同服务器中的两个SQL Server(2000)数据库和位于不同服务器中的一个CRM数据库的数据.
我的问题是,我在一台服务器上有一个名为A的SQL SERVER数据库.在数据库A中,我有一个表为SalesDeleveryOrder,另一个数据库为B,其表名为YearlySalesTarget和QuarterlySalesTarget,在不同服务器上有一个CRM数据库,其表名为SalesDelevryDispatch.
我想将数据库A中的salesDelivery数据和CRM中的SalesDelevryDispatch集成到数据库B中以生成报告.
我正在ASP.NET 1.1中使用动态Excel生成资源库.
请指导我如何实现.
问候,
Atul Sharma
Dear all,
I want to integrate data from different server for generating report.
I have to integrate data from two SQL Server(2000)database located in different server and one CRM database in different server.
My Problem is that, i have a SQL SERVER Database named as suppose A on one server. In database A I have a table as SalesDeleveryOrder, an other SQL Server Database as B having table Name YearlySalesTarget and QuarterlySalesTarget and A CRM Database on diffrent server having table name SalesDelevryDispatch.
I want to integrate salesDelivery data from database A and SalesDelevryDispatch from CRM into database B to generate report.
I am generating repot using dynamic excel in ASP.NET 1.1
Pls guide me how it is possible.
Regards,
Atul Sharma
推荐答案
两个服务器的版本是否相同?您可能还没有听说过它,但是至少从2000开始,SQL Server允许您配置链接服务器.请在此处查看此链接(也有描述2005和2008年的链接): http://msdn.microsoft.com/en-us/library/aa213778(v = sql.80).aspx [
Are both servers the same version? You may not yet heard about it, but SQL Server from 2000 at the least let you configure linked servers. See this link here (there are also sites that describe this for 2005 and 2008): http://msdn.microsoft.com/en-us/library/aa213778(v=sql.80).aspx[^].
Best regards,
-MRB
这篇关于整合来自不同服务器的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!