question

abdmajid.pk avatar image
abdmajid.pk asked

Distributed Databases

I NEED YOUR HELP ANY IDEA ANY SOLUTION 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?
replicationdatabasedatabase-designdatabase-snapshot
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.