SQL Server Behavior Options Namespace
Published 15 January 2025
This namespace contains the configurations relating to SQL Server database comparison and script generation behavior.
Settings
| Setting | Type | Description |
|---|---|---|
addCreateOrAlterForRerunnableScripts |
Boolean | Use CREATE OR ALTER statements for rerunnable objects. |
addDropAndCreateForRerunnableScripts |
Boolean | Use DROP and CREATE statements for rerunnable scripts. |
addNoPopulationToFulltextIndexes |
Boolean | Adds the NO POPULATION clause to all new fulltext indexes. |
addObjectExistenceChecks |
Boolean | Add IF EXISTS statements to check for object existence before modifications in generated scripts. |
addOnlineOnWhenCreatingIndexesOrAlteringColumns |
Boolean | Adds the ONLINE = ON option when creating relational indexes or altering columns. |
addWithEncryption |
Boolean | Adds WITH ENCRYPTION to stored procedures, functions, views, and triggers. |
considerNextFilegroupInPartitionSchemes |
Boolean | If a partition scheme contains a next filegroup, the next filegroup is considered in the comparison. |
decryptEncryptedObjects |
Boolean | Decrypt encrypted objects. |
disableAutoColumnMapping |
Boolean | Disable automatic mapping of similarly named columns. |
dontUseAlterAssemblyToChangeClrObjects |
Boolean | Drop and recreate CLR assemblies and dependent objects rather than using ALTER ASSEMBLY. |
forbidDuplicateTableStorageSettings |
Boolean | Forbids setting file group, file stream, partition scheme, and data compression options on both a table and a clustered index or non-inlined clustered constraint on that table. |
forceColumnOrder |
Boolean | If additional columns are inserted into the middle of a table, this option forces a rebuild of the table so the column order is correct following deployment. |
ignoreMigrationScripts |
Boolean | Ignore SQL Source Control migration scripts in comparisons. |
includeRoleExistenceChecks |
Boolean | Checks for existence of role objects before creating them. |
includeSchemaExistenceChecks |
Boolean | Checks for existence of schema objects before creating them. |
inlineFulltextFields |
Boolean | Script out fulltext indexes as a single CREATE statement instead of may ALTER statements. |
inlineTableObjects |
Boolean | Script out definitions as part of the table's body where possible for primary keys, foreign keys etc. |
useCaseSensitiveObjectDefinition |
Boolean | Perform comparisons on objects case sensitively. |
useDatabaseCompatibilityLevel |
Boolean | Use a database's compatibility level instead of the SQL Server version. |
useSetStatementsInScriptDatabaseInfo |
Boolean | Use RedGateDatabaseProperties.xml to store/recover set statements for objects. |
writeAssembliesAsDlls |
Boolean | CLR Assembly objects will be written in their true DLL form rather than a sql script containing a binary blob in hex. |
