SQL Server Behavior Options Namespace - Flyway

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.
`includeDependencies`	Boolean	Includes dependent objects when comparing and deploying databases.
`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.