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.
UncleTAsked:
Who is Participating?
 
ZberteocCommented:
If the content of the replication is different to the 2 subscribers then you need to create a new publisher and then add the same articles(tables) to it but apply whatever filers you need this time.

This can help:

https://www.mssqltips.com/sqlservertip/4116/sql-server-transactional-replication-static-row-and-column-filters/
0
 
UncleTAuthor Commented:
Thanks so much for the response.  This was the way I was thinking how to do it but I just wanted to be sure.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.