how to add new article to existing publication without reinitialization

hi,
I am working on sql server 2000 replication. I have an
existing publication from server1 to server2 which has 6
tables in the publication. Now I want to add two more
tables into this publication.
How can I do it without have to re-initialize it?
is it always better to re-initialize the replication every
time you add new articles to the publication?
many thanks
JJ
1) use a separate publication is there are no relationships between the new
articles and articles in the existing publication.
2) think about using sp_addarticle. When you use this only the new
article(s) is "reinitialized", the existing publication is not regenerated.
Here is an example:
sp_addarticle 'pubs','jobs', 'jobs'
go
sp_refreshsubscriptions 'pubs'
pubs is my publication jobs is my article name and jobs is the source table.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:295d201c4654a$b05bfba0$a501280a@.phx.gbl...
> hi,
> I am working on sql server 2000 replication. I have an
> existing publication from server1 to server2 which has 6
> tables in the publication. Now I want to add two more
> tables into this publication.
> How can I do it without have to re-initialize it?
> is it always better to re-initialize the replication every
> time you add new articles to the publication?
> many thanks
> JJ
>
|||wow, I ought to try it out! thanks a lot Hilary.
JJ
>--Original Message--
> 1) use a separate publication is there are no
relationships between the new
>articles and articles in the existing publication.
>2) think about using sp_addarticle. When you use this
only the new
>article(s) is "reinitialized", the existing publication
is not regenerated.
>Here is an example:
>sp_addarticle 'pubs','jobs', 'jobs'
>go
>sp_refreshsubscriptions 'pubs'
>pubs is my publication jobs is my article name and jobs
is the source table.
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:295d201c4654a$b05bfba0$a501280a@.phx.gbl...
every
>
>.
>
|||hi Hilary,
Is the sp_addarticle the same thing when I do it through
the replication wizard (click on the publication property
and add more article in the 'article' tab)? if I do in
the wizard, will still only the new articles get re-
initialized?
JJ
>--Original Message--
> 1) use a separate publication is there are no
relationships between the new
>articles and articles in the existing publication.
>2) think about using sp_addarticle. When you use this
only the new
>article(s) is "reinitialized", the existing publication
is not regenerated.
>Here is an example:
>sp_addarticle 'pubs','jobs', 'jobs'
>go
>sp_refreshsubscriptions 'pubs'
>pubs is my publication jobs is my article name and jobs
is the source table.
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:295d201c4654a$b05bfba0$a501280a@.phx.gbl...
every
>
>.
>
|||Yes it is the same thing. However, thru EM, there is no
way to refresh only new articles in the subsriptions.
When you click on reintialize all subscriptions, it
reinitializes everything. At that time, you should use
SPRC sp_refreshsubscriptions. However, I haven';t seen
this proc working with PUSH subscription though. It only
works with PULL Subscriptions.

>--Original Message--
>hi Hilary,
>Is the sp_addarticle the same thing when I do it through
>the replication wizard (click on the publication
property[vbcol=seagreen]
>and add more article in the 'article' tab)? if I do in
>the wizard, will still only the new articles get re-
>initialized?
>JJ
>relationships between the new
>only the new
>is not regenerated.
>is the source table.
in[vbcol=seagreen]
>message
an[vbcol=seagreen]
has 6
>every
>.
>