如何组合来自不同数据库SQL Server的数据 [英] How to combine data from different databases SQL Server

问题描述

我的主应用程序有主数据库和分支应用程序，它有自己的小数据库。



分支应用程序将数据库发送到主应用程序（如一个文件），我正试图找到一种方法，我在分支数据库中读取信息并将其插入主数据库，以便能够从主应用程序中检查。



简单的例子：

员工的工作时间和工资，每个分支都有自己的员工，工资和与员工相关的信息。分支应用程序有时会将数据库文件发送到要读取的主应用程序。主数据库应包括来自所有分支机构数据库的所有信息，我们应该能够不时更新信息!!



那么实施该数据库的最佳方法是什么？



我无法将数据库放在互联网上，而且分支机构之间的距离太远，无法位于同一网络上。



我正在使用C＃，Linq和SQL Server 2008 ..



感谢您的时间..

I have main application which has the main database and branch application which has small its own database.

The branch application send the database to the main application (as a file), and I'm trying to make a way n which I read the information in the branch database and insert it in the main database to be able to be checked from the main application.

Simple example:
Employees work time and salaries, each branch has its own employees and salaries and information related to the employee. From time to time the branch application send the database file to the main application to be read. The main database should include all information from all branches's databases and we should be able to update information from time to time !!

Then what is the best way to implement that ?

I can't put the database over internet, and branches is so far from each other to be located on same network..

I'm using C#, Linq, with SQL Server 2008 ..

Thanks for your time ..

推荐答案

这就是SSIS的用途， http：// technet .microsoft.com / zh-CN / library / ms141026.aspx [ ^ ]



SSIS并不难学，并且附带Sql和Visual Studio，因此您可能已经拥有访问权限。

This is what SSIS is for, http://technet.microsoft.com/en-us/library/ms141026.aspx[^]

SSIS is not that hard to learn and comes with Sql and Visual Studio so you may already have access.

我认为我要做的是在服务器中创建一个web服务，并且使用它来更新主数据库的辅助应用程序。想一想。

I think what i'd do is creating a webservice in the server,and make the secondary application to use it to update the main database. Think about it.

这篇关于如何组合来自不同数据库SQL Server的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！