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