What are the challenges you face when working across database platforms? Take the survey
Options

How to ignore ROWGUID column during deployment

We have merge replication set up on Production. Due to which ROWGUID columns are created on each replicated table. On develpment/UAT ROWGUID column is not there. During Restore on UAT server, these column disappear.
During deployement on production, toolbelt suggest these (ROWGUID) columns to drop, as it's not in UAT.
Could you please suggest a solution on how to ignore these columns? or any workaround

Thanks
Tagged:

Comments

  • Options
    I'm not overly familiar with merge replication, but have you tried committing the rowguid column to source control? That would certainly prevent it being dropped. My understanding is that if a table has a uniqueidentifier column with the rowguidcol property set, that column will be used for this purpose in replication.
    Software Engineer
    Redgate Software
  • Options
    Are you suggesting to create these column in UAT server for all the tables involved in replication and then add it in source control? So that UAT and production schema becomes same.
  • Options
    Yes, so essentially you would have the rowguid column in each environment.
    Software Engineer
    Redgate Software
Sign In or Register to comment.