Sql Server 2008 - Replication from one database to multiple databases
Posted on 2016-08-24
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.