asked on Sql Server 2008 - Replication from one database to multiple databases
Hello All,
I am trying to get two transaction replications going from one database to 2 other databases. Here is what I currently have.
I've got a Transaction Replication set up between MAINDB and DB2 (See Below)
MainDB = My main database. It contains tables such as CASETABLE, ADDRESSTABLE, SUBJECTTABLE
DB2 = This is a DB that I am replicating CASETABLE, ADDRESSTABLE and SUBJECTTABLE using Transaction Replication.
I am wanting to also have a Transaction Replication of CASETABLE, ADDRESSTABLE and SUBJECTTABLE from MainDB to DB3 but I'm wanting filters put on some of the rows.
Can I create another Publication on MainDb > select the Tables I need and filter them and have it go to another subscriber?
Is this possible and can it be accomplished.
I am trying to get two transaction replications going from one database to 2 other databases. Here is what I currently have.
I've got a Transaction Replication set up between MAINDB and DB2 (See Below)
MainDB = My main database. It contains tables such as CASETABLE, ADDRESSTABLE, SUBJECTTABLE
DB2 = This is a DB that I am replicating CASETABLE, ADDRESSTABLE and SUBJECTTABLE using Transaction Replication.
I am wanting to also have a Transaction Replication of CASETABLE, ADDRESSTABLE and SUBJECTTABLE from MainDB to DB3 but I'm wanting filters put on some of the rows.
Can I create another Publication on MainDb > select the Tables I need and filter them and have it go to another subscriber?
Is this possible and can it be accomplished.
Microsoft SQL Server 2008
Last Comment
UncleT
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks so much for the response. This was the way I was thinking how to do it but I just wanted to be sure.