Transactional Replication in SQL SERVER 2008

• arctica82

  Ten Centuries

  Points: 1013

  More actions

  April 22, 2009 at 6:44 pm

  #203861

  Hi guys,

  I have question about creation of Transactional replication in SQL SERVER 2008,Is it possible to change an article(like changing datatype of a replicated field or renaming a replicated field) in Replication environment ,without rebuilding the whole replication.In SQL SERVER 2000,we have to rebuild the replication again.Just in case the artivle was new,we could add them through article properties.

  Thanks

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  April 27, 2009 at 5:19 am

  #984261

  SQL 2008 supports the replication of certain DDL commands like ALTER TABLE. So you should be fine with the changes you mentioned.

  For more info see http://msdn.microsoft.com/en-us/library/ms151870.aspx

  and http://msdn.microsoft.com/en-us/library/ms152562.aspx

  [font="Verdana"]Markus Bohse[/font]