You don't need to drop the publication, but you will have
to drop the subscriptions to allow modifications to take
place for the publication itself. Once the subscriptions
are dropped, you can add the table to the publication.
Once you are done, re-register all the subscriptions, and
flag the snap shot agent to run immediately so that it
syncs all the databases.
Hope this helps,
Jose R
[quoted text, click to view] >-----Original Message-----
>All,
>I need to add one table into my existing replication
process. I can use the GUI to include the new table into
the existing publisher. However, the replication only
works for the original tables. No replication is
happening on the newly added table.
[quoted text, click to view] >What can I do to make replication working on this new
table. I don't want to drop the repliation on all tables
and resetup aging.
[quoted text, click to view] >
>Thanks.
>.
Hi Jose,
[quoted text, click to view] >> -----Original Message-----
>> All,
>> I need to add one table into my existing replication
> process. I can use the GUI to include the new table into
> the existing publisher. However, the replication only
> works for the original tables. No replication is
> happening on the newly added table.
>> What can I do to make replication working on this new
> table. I don't want to drop the repliation on all tables
> and resetup aging.
>>
> You don't need to drop the publication, but you will have
> to drop the subscriptions to allow modifications to take
> place for the publication itself. Once the subscriptions
> are dropped, you can add the table to the publication.
> Once you are done, re-register all the subscriptions, and
> flag the snap shot agent to run immediately so that it
> syncs all the databases.
sorry for interfering, but your answer confused me a little ;-)
When we have to alter a publication by adding (or deleting) a table or any
other object, we do not drop the subscriptions but reinitialize all of them
(after we've created a new snapshot of course). Or is reinitialize and drop
the same for you?
Or did I get something wrong?
Regards
Susanne
Susanne,
Reinitializing is not the same as dropping and re-creating the
subscription. Your method is correct. After adding an article to a
publication, you must recreate the snapshot and reinitialize the
subscribers.
Jose's method will work too, though it requires more work to do it that
way. He may have been referring to SQL 7.0. With SQL 7.0, you had to
delete all the subscriptions before making changes to the publication.
Regards,
Shirley
SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
