Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.replication > #5
| X-Received | by 2002:ac8:109:: with SMTP id e9mr35619qtg.233.1574200782384; Tue, 19 Nov 2019 13:59:42 -0800 (PST) |
|---|---|
| X-Received | by 2002:a25:dc05:: with SMTP id y5mr123282ybe.37.1574200781856; Tue, 19 Nov 2019 13:59:41 -0800 (PST) |
| Path | csiph.com!eternal-september.org!feeder.eternal-september.org!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!j16no4977433qtl.0!news-out.google.com!g53ni452qtg.0!nntp.google.com!j16no4977425qtl.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | microsoft.public.sqlserver.replication |
| Date | Tue, 19 Nov 2019 13:59:40 -0800 (PST) |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=70.163.37.12; posting-account=znYJzwoAAADFFm2hCsT1YJoSKubcMLNQ |
| NNTP-Posting-Host | 70.163.37.12 |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <4a9c98e1-b398-493e-8615-708aaac86cab@googlegroups.com> (permalink) |
| Subject | Help designing replication in multi server environment |
| From | QuarryYeti <scott.morstorf@gmail.com> |
| Injection-Date | Tue, 19 Nov 2019 21:59:42 +0000 |
| Content-Type | text/plain; charset="UTF-8" |
| Xref | csiph.com microsoft.public.sqlserver.replication:5 |
Show key headers only | 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
Help designing replication in multi server environment QuarryYeti <scott.morstorf@gmail.com> - 2019-11-19 13:59 -0800
csiph-web