Can SQL Data Compare remember a sequence of tables to affect?

• 
  Hi @ShowJ
  
  Can I ask, have you looked into any of the options that SQL Data Compare provides?
  
  It should be a default option, have you got "Disable foreign keys" enabled? 
  
  So essentially this disables the FK constraint and deploys the data (that should meet all integrity constraints) and then re-enables the FK.
  
  Here's some documentation breaking them down: https://documentation.red-gate.com/sdc/setting-up-the-comparison/setting-project-options

  DanC August 20, 2020 16:46

  - 0 +
• 

  DanC said:

  Hi @ShowJ
  
  Can I ask, have you looked into any of the options that SQL Data Compare provides?
  
  It should be a default option, have you got "Disable foreign keys" enabled? 
  
  So essentially this disables the FK constraint and deploys the data (that should meet all integrity constraints) and then re-enables the FK.
  
  Here's some documentation breaking them down: https://documentation.red-gate.com/sdc/setting-up-the-comparison/setting-project-options

  That was the first thing I tried. Didn't work.
  
  I should also mention that all the primary keys are identity, auto-number columns.

  ShowJ September 04, 2020 08:10

  - 0 +
• 

  DanC said:

  Hi @ShowJ
  
  Can I ask, have you looked into any of the options that SQL Data Compare provides?
  
  It should be a default option, have you got "Disable foreign keys" enabled? 
  
  So essentially this disables the FK constraint and deploys the data (that should meet all integrity constraints) and then re-enables the FK.
  
  Here's some documentation breaking them down: https://documentation.red-gate.com/sdc/setting-up-the-comparison/setting-project-options

  That was the first thing I tried. Didn't work.
  
  I should also mention that all the primary keys are identity, auto-number columns.

  ShowJ September 04, 2020 08:10

  - 0 +
• 

  DanC said:

  Hi @ShowJ
  
  Can I ask, have you looked into any of the options that SQL Data Compare provides?
  
  It should be a default option, have you got "Disable foreign keys" enabled? 
  
  So essentially this disables the FK constraint and deploys the data (that should meet all integrity constraints) and then re-enables the FK.
  
  Here's some documentation breaking them down: https://documentation.red-gate.com/sdc/setting-up-the-comparison/setting-project-options

  That was the first thing I tried. Didn't work.
  
  I should also mention that all the primary keys are identity, auto-number columns.

  ShowJ September 04, 2020 08:10

  - 0 +
• 
  Hi @ShowJ
  
  Thanks for the update, going to need a bit more info from you in order to troubleshoot this!
  
  I'm going to follow up via a support ticket!

  DanC September 07, 2020 13:54

  - 0 +

Add comment

Please sign in to leave a comment.