In product
ion, we have a transactional replication between 2 servers with data from one database going from server A to Server B. We now want to add another server C for the short period of time and get replication working from Server A to Server C.
So in short, one database from server A replicated one way to Server B and Server C simultaneously. Is that possible in SQL2008 standard edition ? And if yes then which type of replication would work ?
Replicate one database in one server to 2 other servers SQL2008
replicationsql-server-2008standard-edition
Related Question
- Sql-server – SQL Server: subscriber as publisher and hierarchical replication
- Sql-server – How to Properly shutdown and disassemble SQL Database Replication
- Sql-server – Replication To Enterprise & Standard Edition subscribers
- Sql-server – Two-way replication between SQL Server 2005 and SQL Server 2008
- Sql-server – Database Replication SQL Server
- Sql-server – Transactional Data Replication, SQL Server version compatibility
Best Answer
Yes this is possible, and most types of Replication should allow you to accomplish this, but since you said you only need it to synchronize in one direction then Transactional Replication is probably the most ideal solution. It's also typically the most flexible type of Replication, especially since it supports heterogenous Publishers:
Since your database on
ServerA
is already setup as a Publisher, you likely only need to follow the second set of steps of setting up a new subscription per Create a subscription to the transactional publication.Note that any tables replicated via Transactional Replication require primary keys defined on them, and any indexed views require a unique clustered index.