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