The IN_DB_UPGRADE_SP_UPGRADE_SETUP procedure will create the IN_DB_UPGRADE_CONTROL_UPGRADE table which holds the default parameter values that are used if not otherwise specified when executing the various upgrade procedures.
Note: For instructions on changing the default upgrade parameters
after setup, please refer to the View and update Upgrade
parameter default values section.
For upgrades where the schema version is less than 7.5.0.0 this procedure will also create the IN_DB_UPGRADE_CONTROL_SYNC table which holds the default parameter values that are used if not otherwise specified when executing for the various synchronization procedures.
Note: For instructions on changing the default synchronization
parameters after setup, please refer to the View and
update Synchronization parameter default values section.
In SSMS or at the command prompt (sqlcmd), execute the following procedure.
EXEC inuser.IN_DB_UPGRADE_SP_UPGRADE_SETUP;
The following parameters are available to use.
- @TARGET_SCHEMA_VERSION
- @FILEGROUP_NAME
- @DEFAULT_MAX_MINUTES
- @DEFAULT_MAX_DOP
- @DEFAULT_FILLFACTOR
- @DEFAULT_BATCH_SIZE
- @SYNC_DEFER_FK_CHECK
- @SYNC_KEEP_SRC_TABLE