How to combine data from different databases SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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 ..

Posted 29-Jul-14 14:43pm

firas_hamzeh

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2014-07-29T16:14:00

Solution 1

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.

Posted 29-Jul-14 16:14pm

ZurdoDev

Comments

firas_hamzeh 30-Jul-14 9:25am

It seems that SSIS is related only to SQL Server 2014 !!
And I told you I'm using 2008.

ZurdoDev 30-Jul-14 9:52am

No, it has been around for a long time. Since 2005. In the link I sent you, there is a drop down labeled other versions. Just pick your version.

Pikoh · Answer 2 · 2014-07-29T21:06:00

Solution 2

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.

Posted 29-Jul-14 21:06pm

Pikoh

Comments

firas_hamzeh 30-Jul-14 9:26am

The problem as I mentioned that I couldn't put the database on the internet server to be accessed by every body !!

Pikoh 30-Jul-14 10:10am

Well,tecnically you database won't be in the internet. Just a webservice,with as many security as required. I can't see another way to do it,maybe using a vpn?