ContextQMD
Back to Flyway

SQL Server Data Deployment Options Namespace

documentation/Reference/Configuration/Redgate Compare Namespace/Redgate Compare SQL Server Namespace/SQL Server Data Deployment Options Namespace.md

latest3.5 KB
Original Source

{% include enterprise.html %}

This namespace contains the configurations relating to SQL Server static data deployment.

Settings

SettingTypeDescription
disableDdlTriggersBooleanDisables then re-enables DDL triggers in the deployment script.
disableDmlTriggersBooleanDisables then re-enables DML triggers on tables and views in the deployment script.
disableForeignKeysBooleanDisables then re-enables foreign keys in the deployment script.
dontIncludeCommentsInScriptBooleanDo not include the comments in the deployment script.
dropPrimaryKeysIndexesAndUniqueConstraintsBooleanDrops then recreates primary keys, indexes, and unique constraints in the deployment script.
reseedIdentityColumnsBooleanReseeds identity values in the target database after deployment.
skipIntegrityChecksForForeignKeysBooleanUses WITH NOCHECK to skip integrity checks for foreign key constraints.
transportClrDataTypesAsBinaryBooleanUses the binary representation of CLR types in the deployment script.