Replication setup

From: massa (massa_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 07:45:08 -0800

How many articles can take part in merge replication?
I need to replicate about 200 tables. From them 25 are common for all my
subscribers and do not need to be filtered. Other I plan to filter with
static filters.
Is there benefit to allocate this 25 common tables in separate publication
or it will be better to include them in all publications where tables with
filters are placed?

Relevant Pages

  • Re: Cannot modify horizontal filter
    ... salesman and he has a territory. ... With traditional replication if you change a territory of a salesman from CA ... With Join filters all the rows which are in the join will move ... reason for the row filter is that certain tables in the publisher will ...
    (microsoft.public.sqlserver.replication)
  • Re: Join filters an generation ids
    ... you might want to look up join filters in BOL - this is precisely what ... > Looking for a SQL Server replication book? ... >> get sent to a publisher or subscriber. ... >> the replication engine isn't going to know that you want it to dig through ...
    (microsoft.public.sqlserver.replication)
  • Re: Join filters an generation ids
    ... you might want to look up join filters in BOL - this is precisely what ... You will have to add the -HostName 'mike' switch to your pull agent. ... Looking for a SQL Server replication book? ... > The merge engine works against the MSmerge_contents and MSmerge_genhistory ...
    (microsoft.public.sqlserver.replication)
  • Re: Table owner in dynamic filtered merge replication
    ... Kestutis Adomavicius has posted a zip of stored procedures which he has ... Looking for a book on SQL Server replication? ... I can apply dynamic filters properly. ... However when my DB owner ...
    (microsoft.public.sqlserver.replication)
  • Re: Repl Topology
    ... > REPLICATION clause when creating the tables. ... > Another thing about NOT FOR REPLICATION clause mentioned earlier. ... > Most of my publications are merge publications. ... > thread I started - Merge replication and dynamic filters. ...
    (microsoft.public.sqlserver.replication)