Do not include plumbing for Transaction Sync...

• 

  mikea wrote:

  This option does not seem to work. I have restored a production database that has replciation to my (local) machine, made changes, then compared.
  
  In older versions, this would let met compare the tables and not have every table show up as being different. It does not work any more.

  
  Mike,
  
  are you sure you mean the "Do not include plumbing for Transaction Sync..." option? This option affects the synchronization script, and should not affect what differences are detected between databases. Also, could you tell me what differences show up for those tables? Many thanks,
  
  Andras

  Andras B December 08, 2005 05:51

  - 0 +
• 

  Andras wrote:

  Mike,
  
  are you sure you mean the "Do not include plumbing for Transaction Sync..." option? This option affects the synchronization script, and should not affect what differences are detected between databases. Also, could you tell me what differences show up for those tables? Many thanks,
  
  Andras

  
  The part that shows up as different is the triggers for replication of the tables, even though I have that option checked.

  mikea December 08, 2005 09:27

  - 0 +
• 

  mikea wrote:

  Andras wrote:

  Mike,
  
  are you sure you mean the Do not include plumbing for Transaction Sync? This option affects the synchronization script, and should not affect what differences are detected between databases. Also, could you tell me what differences show up for those tables? Many thanks,
  
  Andras

  
  The part that shows up as different is the triggers for replication of the tables, even though I have that option checked.

  
  The "Do not include plumbing for Transaction Sync.." option has not much to do with triggers. Do you mean the "Ignore DML triggers" option? (the "Do not include plumbing for Transaction Sync" affects only synchronization and has no effect on comparison.
  
  Regards,
  Andras
  
  Andras

  Andras B December 08, 2005 10:31

  - 0 +
• 

  Andras wrote:

  The "Do not include plumbing for Transaction Sync.." option has not much to do with triggers. Do you mean the "Ignore DML triggers" option? (the "Do not include plumbing for Transaction Sync" affects only synchronization and has no effect on comparison.
  
  Regards,
  Andras
  
  Andras

  
  OK, I used the "Ignore DML Triggers" option and the tables compared O.K.
  
  However, I have a feature request. Let me be able to ignore the System Triggers like for replication, and compare the User defined triggers, otherwise, I cannot compare the triggers between my development and live machines.
  
  Thanks,
  Mike

  mikea December 08, 2005 11:18

  - 0 +
• 

  mikea wrote:

  
  OK, I used the "Ignore DML Triggers" option and the tables compared O.K.
  
  However, I have a feature request. Let me be able to ignore the System Triggers like for replication, and compare the User defined triggers, otherwise, I cannot compare the triggers between my development and live machines.
  
  Thanks,
  Mike

  
  Mike,
  I'm happy that the option issue is sorted now. Also thank you for the feature request. For the next release we will not include it; however, the following dot release will contain an option to ignore replication triggers.
  
  Regards,
  
  Andras

  Andras B December 08, 2005 11:40

  - 0 +

Add comment

Please sign in to leave a comment.