Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the same databases in three cities which each database have three tables:

1- tbl_worker
and cities are:city1,city2,city3

city2 and city3 insert informations in their databases.

The city1 database should be updated every 1 hour from data inserted in city1 and city2 databases.

For example, the data inserted in tbl_kargah in city1 and city2 databases should be merged and inserted into tbl_kargah of city1 database every 1 hour.

Will using replication cover my requirement and which replication?

As I read in MSDN the publisher distribute data in subscribers, but I have different publishers and 1 subscriber.

share|improve this question

migrated from Apr 23 '11 at 8:37

This question came from our site for professional and enthusiast programmers.

Yes it is possible to have many publishers and only one subscriber. You can also have one publisher and many subscribers. So in your case you will be able to publish from City1 and City2 and subscribe only City1 on those publishers. You can use this link to have an overview of the replication engine and how to setup it.

Hope this was helpful

share|improve this answer

Yes this can be done. You'll want to make sure you set the publication properties for the object correctly to ensure that you don't wipe the table if you reinit the subscriptions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.