Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sql Server 2008 - Replication from one database to multiple databases

Posted on 2016-08-24
2
Medium Priority
?
54 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
Zberteoc earned 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

722 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