How can we help you today?

How can we help you today?

How to disable the Dropping foreign keys during a deploy.

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

bernieconway July 01, 2019 20:04

0

Comments

3 comments

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

Victoria W July 03, 2019 07:28

0
yes there is static data.

bernieconway July 03, 2019 13:49

0
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

Pete_Ruiz July 09, 2019 23:48

0

Add comment

Please sign in to leave a comment.