How to disable the Dropping foreign keys during a deploy.

bernieconway

One of our deploys is dropping all of the foreign keys when deploying and then re-adds them in. What causes this behavior? 

Victoria W

Hi @bernieconway

Is this from command line and is there static data? (static data is only deployed when using the command line).

The SDC option "Disable Keys" is enabled by default, but you can disable it by specifying the options needed via the /DataCompareOptions switch - https://documentation.red-gate.com/sc13/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/DataCompareOptions:%3Coption1%3E,%3Coption2%3E,%3Coption3%3E

bernieconway

yes there is static data.

Pete_Ruiz

Hi @bernieconway

Was there any change to the static data or to the table where the foreign keys are being dropped? Does adding the DisableKeys option prevent the foreign keys from being dropped?

Kind regards,

Pete Ruiz