Drop / Re-create replicated Table

• sqlrumble

  Default port

  Points: 1458

  More actions

  March 13, 2006 at 5:40 am

  #91516

  Hello,

  We are using merge replication and I need to make some schema changes.

  How can I do the following:

  * Drop a table from the database

  * Modify a column to change or apply:

  data Type, length , default value , primary key attribute , set contrainsts

  * Insert new Indexes (CLUSTERED / NON - CLUSTERED)

  Any help is greatly apprieciated.

   

  Thanks

   

   

   

• rangark

  Right there with Babe

  Points: 738

  More actions

  March 14, 2006 at 7:04 am

  #626489

  Drop a table from the database

  You need to stop the replication and remove the table from the publication and regenerate the snapshot

  Modify a column to change or apply:

  can be done using sp_repladdcolumn, sp_repldropcolumn

  Alerting a datatype -need to remove the column and add the column with the new datatype.

  Redefiing of primary key need to considered similar to droping a table and adding a table

  Index -adding/modifying need to done at the publisher and at the subscriber(s) as required. Index will not be replicated by default

   

  Hope this helps

   

  rangark

• sqlrumble

  Default port

  Points: 1458

  More actions

  April 4, 2006 at 8:32 am

  #630674

  Thanks!!