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 droptable.com
http://www.droptable.com/Uwe/Forums...ation/200602/1
Yes - you can add the articles to an existing publication. If you run the
snapshot agent, the new articles will be passed over on synchronization.
Running the snapshot will snapshot just the new articles in the case of
transactional, or all the articles in the case of merge. Either way, just
the new tables will be synchronized.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||tk u very much ..
Paul Ibison wrote:
>Yes - you can add the articles to an existing publication. If you run the
>snapshot agent, the new articles will be passed over on synchronization.
>Running the snapshot will snapshot just the new articles in the case of
>transactional, or all the articles in the case of merge. Either way, just
>the new tables will be synchronized.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
Message posted via http://www.droptable.com
|||Hi ,
After i have added a new article and when i tried to change it's name i was
prompted "
Changing this property automatically marks for reinitialization all
subscriptions that support automatic intialization. Reinitialization will
occur the next time the snapshot agent and disribution agent run. note that
you must manually reinitialize the affected replicated objects at
subscriptions that do not support automatica reinitialization.
are you sure you want to change this property and reinitlization all
subscriptions ?"
my quest :
1) wat's meant by automatic initalization ? i have set up my replication to
be continuous mode, is it referring to this ?
2) will it reinitilizates ALL subscriptions ? or just the subscription that
is affected by this change ?
appreciate ur further advise
tks & rdgs
Paul Ibison wrote:
>Yes - you can add the articles to an existing publication. If you run the
>snapshot agent, the new articles will be passed over on synchronization.
>Running the snapshot will snapshot just the new articles in the case of
>transactional, or all the articles in the case of merge. Either way, just
>the new tables will be synchronized.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
Message posted via http://www.droptable.com
|||You should be able to avoid this error by dropping the article then readding
with the new destination name specified at the time of creation:
exec sp_dropsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
exec sp_droparticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
exec sp_addarticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.source_table = 'tEmployees'
, @.destination_table = 'mynewname'
exec sp_addsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)