Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1- tbl_worker
2-tbl_workshop
3-tbl_users
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
add comment

migrated from stackoverflow.com Apr 23 '11 at 8:37

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

2 Answers

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. http://technet.microsoft.com/en-us/library/ms151198.aspx

Hope this was helpful

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.