Replicating database schema changes in "daisy chain" situation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tommy (Tommy_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 12:37:03 -0800

We have a setup where SQL Server A servers as a Master database. SQL Server B
is installed in another country and replicates key master data from server A.
MSDE Instance C replicates with Server B to receive this master data as well
as merge data that is shared only between B and C. We recently needed to
change some column widths. I used the sprocs to add and drop columns to
recreate the columns with the new widths on server A. When we try to
replicate this to server B we get an error "The schema script 'exec
sp_repldropcolumn '[dbo].[<Table Name]', 'Column Name>', 1' could not be
propagated to the subscriber." It seems that since server B's tables are in
publications, the changes cannot be applied from server A. I tried running
the same SQL statements I ran on server A on server B to make the column
changes but it tells me that "Schema replication failed because database
<database name> on server <server> is not the original Publisher of table
<table name>." (this is returned from the sp_repladdcolumn call).

Any ideas on how to propogate the schema cahnges?

Tommy

Relevant Pages

  • Re: Replicating database schema changes in "daisy chain" situation
    ... create database central ... exec sp_replicationdboption 'central','merge publish','true' ... SQL Server B> is installed in another country and replicates key master data from server A.> MSDE Instance C replicates with Server B to receive this master data as well> as merge data that is shared only between B and C. ...
    (microsoft.public.sqlserver.replication)
  • RE: Can Windows 2003 Server implicitly replicate SQL Server 2005?
    ... Now that you told me now I know that it only replicates ... Since Windows 2003 Server Domain Controllers replicate themselves, ... wondering when Windows 2003 Server exists as a domain controller in a domain ...
    (microsoft.public.sqlserver.replication)
  • ER problem---CDRACK cause rootserver crash
    ... I have any problems with ER rootserver; ... 16:20:23 Informix Dynamic Server 2000 Version 9.20.UC3 ... Constantly the rootserver crashes by reason of CDRACK_0 or CDRACK_1. ... The problem appears after I define new replicates between 2 leaf ...
    (comp.databases.informix)
  • Re: Exchange 2003 / 2007 Recipient policy
    ... replicates, its just the users that are created in AD on the 2003 ... exchange servers do not get populates on either server with the email ... Yes, but it's not the /Exchange/ server, it's a domain controller, ... And it's cleared when that GUID doesn't appear in that property (or ...
    (microsoft.public.exchange.admin)
  • Re: network over Broadband
    ... >> replicates the data locally. ... >therefore network browsing). ... >Second server at remote site. ...
    (microsoft.public.windows.server.sbs)