Updating a merge replication - 12-18-2006 , 01:03 PM
We have an SQL 2000 merge replication set that consists of 2 publications.
One is for tables only and the other is for SQL views and stored procs.
I need to create a new table and revise some triggers in other tables. I
also have to add a new SQL view that will be a merge object also. Can I do
all of this in code and then re-create both publications? Thanks.
Re: Updating a merge replication - 12-18-2006 , 09:53 PM
I normally put all my schema only objects in a snapshot publication. This
way each time the snapshot agent runs and distributes the schema only
objects all modifications to these objects (procs, views, and functions) are
replicated. If they are part of a transactional or merge publication changes
to schema only objects will not be picked up.
Another option is to use sp_addscriptexec to run a script on all unc
To add a new table try to use sp_addmergearticle. This may require a new
snapshot for all articles.
You can add/modify/drop triggers on merge published/subscribed tables.
Looking for a SQL Server replication book?
Looking for a FAQ on Indexing Services/SQL FTS
"David" <dlchase (AT) lifetimeinc (DOT) com> wrote