Distributed Databases


SCENARIO: An organization suppose Jason industries have its branches in different regions of country. In each branch there is a local database where they maintain their data locally. Suppose one branch in New York, one in Washington, one in Texas. There is a main database in the main branch of the organization. At the end of each week or month each branch submits their data to the main database. I can say that they synchronize there data in the end of week or month. Note that each branch has its local database where data is kept in disconnected mode from main database. Only at end of each week or month the whole data of every branch is submitted to the main database.. My question is that is it possible? If yes, what this concept is called? And where from can I get help on this topic?
more ▼

asked Apr 14, 2012 at 05:28 AM in Default

abdmajid.pk gravatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

Without further details, this sounds like a case for merge replication.

This allows a standalone copy for each location which can then be synched whenever required. You need to take care of data collisions (updates of same data in 2 locations), but it is possible if the schema is designed well.

There are other considerations, but looking for merge replication in books online (google the Msdn site) should give a good start.
more ▼

answered Apr 14, 2012 at 12:39 PM

WilliamD gravatar image

25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 14, 2012 at 05:28 AM

Seen: 668 times

Last Updated: Apr 14, 2012 at 12:39 PM