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