DataDeploy and enforce-ri

marcussteiner

Hi all,

does anybody know if the enforce-ri setting in DataDeploy applied during the creation of the script (so that it creates the referential constraint in the database) or will applied each time when a deployment is happening? I'm asking because we have some failing deployment once in a while and completely out of the blue and they always say (constraint violation in the database).

hollis

Migrateduser

It's done when an insert or update is made. If this value is "yes", DD will attempt to delete the record and then insert to enforce referential integrity. Otherwise, it just does the insertion without precendence.

Dave