How to ignore ROWGUID column during deployment

harahara Posts: 2
in DLM Automation
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:
· Share on Twitter

Comments

  • Rob CRob C Posts: 419 Gold 2
    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
    · Share on Twitter
  • harahara Posts: 2
    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.
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    Yes, so essentially you would have the rowguid column in each environment.
    Software Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.