Comments
Sort by recent activity
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. / comments
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 essential...
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. / comments
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 essential...
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. / comments
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 essential...