Monday, March 26, 2012

is it possible to have many publisher and one subscriber ?

we have 20 branches running same application with 20 sql server databases.
can i have replication of data of all branches into one Central Server.
All branches have different branch code in each table as one of the column
of primary key.
Also is this same phenomenon posiible in ORACLE?
Please check out this article for the Multiple Publishers and Central
Subscriber Setup:
http://www.replicationanswers.com/CentralSubscriberArticle.asp
No idea if Oracle supports this natively. If however you are talking about
Oracle Publications as supported in SQL Server 2005 I'll do some checking.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

No comments:

Post a Comment