SQL Server Data Deployment Options Namespace
Published 15 January 2025
This namespace contains the configurations relating to SQL Server static data deployment.
Settings
Setting | Type | Description |
---|---|---|
disableDdlTriggers |
Boolean | Disables then re-enables DDL triggers in the deployment script. |
disableDmlTriggers |
Boolean | Disables then re-enables DML triggers on tables and views in the deployment script. |
disableForeignKeys |
Boolean | Disables then re-enables foreign keys in the deployment script. |
dontIncludeCommentsInScript |
Boolean | Do not include the comments in the deployment script. |
dropPrimaryKeysIndexesAndUniqueConstraints |
Boolean | Drops then recreates primary keys, indexes, and unique constraints in the deployment script. |
reseedIdentityColumns |
Boolean | Reseeds identity values in the target database after deployment. |
skipIntegrityChecksForForeignKeys |
Boolean | Uses WITH NOCHECK to skip integrity checks for foreign key constraints. |
transportClrDataTypesAsBinary |
Boolean | Uses the binary representation of CLR types in the deployment script. |