Databases synchronization - General SQL Database Question & Answer

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » General SQL Database Question & Answer » Databases synchronization

Databases synchronization

Options

Previous Topic · Next Topic

Jawad Khan

Posted: Tuesday, August 12, 2008 7:45:03 AM

Rank: Newbie

Joined: 8/7/2008
Posts: 2
Points: 6
Location: Quetta

Hi all,
Sorry for such a long question…. But I’ll appreciate your reply.

I want to invite you to give me suggestions and ideas about the scenario.

I have developed an application in VB.NET and SQL Server 2005 express edition. This application runs on single PC. This application is running at 3 remote places independently. The information sharing takes place using fax, mail etc. and re-entered at all locations. Of course this is not an optimal solution to the management.

(I know the best solution is to use web based application with a single database residing on the server. But it is not possible, because the remote places are operational for the whole day and the internet connectivity is limited.)

Now the management has decided to change the architecture. Each location will have its own database and data will be stored in it. The data from all three locations will be uploaded to the server residing at Head office at the end of the day and when the internet connectivity is available. The data will be downloaded from server at other locations.

I don’t want the databases of all the 3 locations to be fully synchronized. The server will have the full set of data (i.e. the data uploaded from all three locations + the data entered directly in head office). The locations will have distinct database. The sale record of location A will be uploaded to server but not downloaded to location B and C. Only those records will be downloaded to these databases that are related to them (e.g. the goods transferred from location A to B. This record will be entered at location A and B will download this record from server).

Please advise me what strategy should I use?

Thanks

Scott Whigham

Posted: Tuesday, August 19, 2008 8:09:58 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Hi there -

I would use SSIS for this - it's perfect for this type of scenario. I would create an SSIS package with a variable that identifies what data to retrieve and then I would schedule that to run as a local job on each of the remote servers.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.