This is a discussion on SQL Server Replication within the SQL Server forums, part of the Microsoft SQL Server category; --> In Transactional Replication, is it possible to replicate databases with the same name located on multiple servers (i.e. Pubs ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| In Transactional Replication, is it possible to replicate databases with the same name located on multiple servers (i.e. Pubs on Server1, Server2 and Server3) onto one central server (i.e. Pubs1 on Server4, Pubs2 on Server4, Pubs3 on Server4 etc.). I know I can pull this off using stored procedures but i'm looking for an easier way. Details arn't needed....if it is possible and someone can point me in the right direction, it would be deeply appreciated. Thanks! Clayton |