replicating schema changes

replicating schema changes

Post by Alex » Fri, 11 Jan 2002 02:09:44

Same problem as message posted on
sep 20 2001
no helpful reply after initial question answered on sep25

merge replication problem
2 servers
no. 1 is the distributor/publisher running windows 2000
server and sql 2000 server enterprise (sp1)
no. 2 is the subscriber running windows 2000 and sql 2000
developer (sp1)

merge replication set up and runs successfully, merges
data and new stored procedures.

Implementing schema change using sp_repladdcolumn with
force_reinit_subscription = 1
column added successfully

Recreated snapshot and then ran merge agent

Error received:
The schema script 'exec sp_repladdcolumn '[dbo].
[tblbom]','active',[bit NULL], '%', 1'
could not be propagated to the subscriber.

Any help greatly appreciated.



1. Is there any way to replicate schema changes?


I have one db as a merge replication publisher and several subscribers

Now i need to propagate publisher db schema  changes to subscribers, but i
don't want to reinitialize subscription
Is there any way to do it?

thanks in advance

2. Tes

3. Replicating schema changes

4. ct10w - sql0171N ???

5. add tables and fields

6. Schema change in replicated sites

7. Multi-Language ??

8. Changing the schema of a replicated database in SQL Server 7

9. Replicating table schema changes in 7 v 2000

10. Replicate Database Schema Changes to multiple databases

11. Table Schema Changes for Replicated Tables