changing columns in transactional replication???

  • I'm new to replication. It appears that when I create a publication and subscriber this works fine, but it will not allow me to change a published article, i.e. change a column name or length, etc. I see you can add or delete a column from a published article under the publication properties, but how can you make a change to a column like, changing its name? I saw on some message board someone mentioned a stored procedure for this. Does anyone know what that is, and how to use it or an example? Or is there another way to do this? Please HELP!!! Thanks in advance for any suggestions.

    -Pat

    1. Delete subscription.
    2. Go to Ariticles, unchecked the aticle (table) you want to change.
    3. Make changes in that table using SQL EM or QA.
    4. Make changes to the sp_MSins_<tablename> and sp_MSupd_<tablename> in your subscriber database.
    5. Add that table back to the published articles.
    6. Push subscription back.
    7. Do not initialize snapshot
    8. Test and make sure replicatio working fine with the changed column.
  • thanks. When I go to make changes to the MSins and MSupd sp's it gives me "invalid column name error" when I try to change the column name. It won't accept the changes. Am I doing something wrong? Thanks.

    -Pat

  • Did you complete step 1- 3?

    This procedure has been practiced lot of times, it shouldn't have problem.

    Good luck!

     

     

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply