SQL Server Add Create Or Alter For Rerunnable Scripts Setting
Published 15 January 2025
Description
When this option is selected, CREATE OR ALTER statements are used for the following objects:
- Views
- Stored Procedures
- Functions
- Extended Properties
- DDL Triggers
- DML Triggers
Type
Boolean
Default
false
Usage
Flyway Desktop
This can be set from the comparison options settings in SQL Server projects.
Command-line
./flyway diff -redgateCompare.sqlserver.options.behavior.addCreateOrAlterForRerunnableScripts=true
TOML Configuration File
[redgateCompare.sqlserver.options.behavior]
addCreateOrAlterForRerunnableScripts = true
