Replication - adding new articles

Hi ,

 Previously , i have set up replication to replication Table A , B & C .

 However , now that i need to replicate tables D , E & F , can i simply go to
the properties of for that replication and add in the new tables under
articles ?

 Will this cause a new snapshot to be created and thus bulk copy all the
previously replicated tables as well ? as i do not want such thing to happen

appreciate ur advise

tks & rdgs

-- 
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200602/1
.

Relevant Pages

  • Re: Transactional Replication questions
    ... Will this sub-sequent run of the snapshot publish only new articles or will ... take a brand new snapshot of the entire database? ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication: invalid column name rowguidcol on adding new articles?!?!?
    ... Exactly what do you mean by "recreated my snapshot", ... It sounds like your subscribers are not aware of the added newly articles. ... I'd advise you to drop your subscriptions and publicationand start again ... > I've been running Merge replication successfully now for about 6 months. ...
    (microsoft.public.sqlserver.replication)
  • Re: data gets appended on subscriber
    ... your snapshot is configure to keep the existing table intact. ... this right click on your publication, select the articles tab, click on the ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Replication
    ... order the articles according to DRI which will avoid this entering FK data ... The bad news is that when generating the order, the snapshot agents consults ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Article in publication not replicating
    ... I take it that you are doing plain vanilla transactional replication. ... > All the articles were added at the same time and pushed to the subscriber ... >> Hilary Cotter ...
    (microsoft.public.sqlserver.replication)