Solved

Sql Server 2008 - Replication from one database to multiple databases

Posted on 2016-08-24
2
39 Views
Last Modified: 2016-08-25
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.
0
Comment
Question by:UncleT
2 Comments
 
LVL 26

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 41769404
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
 

Author Closing Comment

by:UncleT
ID: 41770140
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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question