Groups > microsoft.public.sqlserver.replication > #5

Help designing replication in multi server environment

Newsgroups	microsoft.public.sqlserver.replication
Date	2019-11-19 13:59 -0800
Message-ID	<4a9c98e1-b398-493e-8615-708aaac86cab@googlegroups.com> (permalink)
Subject	Help designing replication in multi server environment
From	QuarryYeti <scott.morstorf@gmail.com>

Show all headers | View raw

Looking for some guidance, I have 8 SQL servers, one is at a centralized location and has the 'master' database, and the other 7 servers subscribe to data from the central server. 

Master server has 11 tables that get replicated down, 3 of them have filters in place specific to each location, the others are the full tables, so I actually have 7 different publications set up, 1 for each location that contain 11 tables. 

would it be better to....

have 1 publication for each site, with the 3 filtered tables

then create 1 more publication that has the common tables and have all sites subscribe to that one. 

Any thoughts on this?

Back to microsoft.public.sqlserver.replication | Previous | Next | Find similar

Thread

Help designing replication in multi server environment QuarryYeti <scott.morstorf@gmail.com> - 2019-11-19 13:59 -0800

csiph-web