Author Message

PostPosted: Top

SQL Server >> replication


how to update an artcile?

i have created (via wizard) 1 publication (trans.) with 4 tables and
some filters. it works and replicates to another server with no
problems, but
now i need to ADD 2 additional tables to this publication and pubish it
(all 6 tables), but how to create the snapshot to these 2 tables but not
to all 6 at once, as these tables are the big one (20 mil. records) and
i'll need to add\delete tables and filters from this publication from
time to time. is there any way to modify articles without recreating all
table's snapshot every time i need to make any changes?


SQL Server166