Re: Replication - adding new articles
Tech-Archive recommends: Speed Up your PC by fixing your registry
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)
.
Relevant Pages
- SQL-DMO and VB.Net
... articles is created. ... for there to be a database on MSDE that you can use as one ... snapshot and merge agents. ... >The primary database is on the SQL Server. ...
(microsoft.public.sqlserver.replication) - Re: Snapshot agent doesnt pick new articles
... creating a separate publication for just this one article. ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Specify all articles when subscribing to a publication using concurrent ... snapshot processing. ...
(microsoft.public.sqlserver.replication) - Re: Replication - adding new articles
... snapshot agent, the new articles will be passed over on synchronization. ... Paul Ibison SQL Server MVP, ...
(microsoft.public.sqlserver.replication) - Re: Snapshot agent doesnt pick new articles
... Even that you specify 'ALL' in the articles to subscribe, ... Then try running the snapshot agent. ... this as it doesn't make sense to create a separate publication when I want to ... If you have a pull subscription you have to issue a call to ...
(microsoft.public.sqlserver.replication) - Re: Snapshot agent doesnt pick new articles
... If you have a pull subscription you have to issue a call to ... I am running SQL Server 2000 sp4 with remote distribution server. ... When I adding new articles to the publications, the snapshot ...
(microsoft.public.sqlserver.replication) |
|
