Add new field to replicated table

• daleaanderson

  Newbie

  Points: 9

  More actions

  November 6, 2009 at 9:13 am

  #206309

  We have a table that has been replicated for some time. We added a new field. I ran through the following steps:

  sp_dropsubscription

  sp_droparticle

  alter table on subscriber

  sp_addarticle

  sp_addsubscription

  Run snapshot agent.

  It built the snapshot and is working now, but no data is being replicated for the new field. The new field is checked in the columns list.

• jsph152

  Ten Centuries

  Points: 1366

  More actions

  November 6, 2009 at 10:11 am

  #1076013

  take a look at method b in this article

  http://www.replicationanswers.com/AddColumn.asp

  and at sp_repladdcolumn - http://msdn.microsoft.com/en-us/library/aa239331(SQL.80).aspx

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  November 26, 2009 at 8:45 am

  #1084622

  Hi,

  You should have ALTERED the publisher table.

  Having added it back to the publication and added the subscribers, you re-run the snapshot and distribution agent and away you go..

  Yes sp_repladdcolumn is another option, but your method is sound enough.

  Regards

  Graeme