Ignore ROWGUID column?

• 
  Hello there,
  
  There is already an option available from the comparison->options menu to ignore ROWGUID columns. If this is off, then Data Compare will show you the values of the ROWGUID columns in the results, but these columns can never be synchronized, even if you wanted to.

  Brian Donahue December 29, 2005 09:06

  - 0 +
• 
  The Comparison-->Options I have, and whether they are checked or not, are as follows. These haven't been changed from the defaults. I'm on SDC v3.4.0.8.
  
  [X] Disable Foreign Keys
  [ ] Disable Triggers
  [ ] Drop primary keys, indexes and unique constraints
  [X] Include timestamp columns
  [ ] Do not use transactions
  [ ] Exclude IDENTITY columns
  [ ] Trim trailing spaces
  
  Nothing about ROWGUID. I went through on the wizard and unchecked each of the rowguid columns from the tables before the compare.
  
  This fixed the compare, but I'm unable to sync the rest of the data. i.e. keep the rowguid, but update the names, phone numbers, etc.
  
  I think I can probably gut the script and take out all the rowguid references from the statements, but is there another option?

  lund0529 December 29, 2005 09:36

  - 0 +
• 
  Nevermind, I unchecked the column next to ROWGUID in one table. With that corrected, the sync worked as expected.
  
  Thanks!

  lund0529 December 29, 2005 09:43

  - 0 +
• 
  Sorry I got ROWGUID confused with timestamp...

  Brian Donahue December 29, 2005 12:45

  - 0 +

Add comment

Please sign in to leave a comment.