The following examples show some of the procedures with parameters specified during execution.
Specification of the parameters are not required during execution unless you want to override the default values. If you do not specify a parameter, then the default values are used.
EXECUTE inuser.IN_DB_UPGRADE_SP_UPGRADE_SETUP @TARGET_SCHEMA_VERSION = '7.9.0.0', @FILEGROUP_NAME = 'PRIMARY', @DEFAULT_MAX_MINUTES = 60, @DEFAULT_MAX_DOP = 4, @DEFAULT_FILLFACTOR = 95, @DEFAULT_BATCH_SIZE = 100000, @SYNC_DEFER_FK_CHECK = 'NO', @SYNC_KEEP_SRC_TABLE = 'YES'; EXECUTE inuser.IN_DB_UPGRADE_SP_UPTIME_STEPS @MAX_MINUTES = 60, @MAX_DOP = 4, @FILLFACTOR = 95; EXECUTE inuser.IN_DB_UPGRADE_SP_SYNC_SETUP_IN_DOC @MAX_MINUTES = 60, @MAX_DOP = 0, @BATCH_SIZE = 100000, @DEFER_FK_CHECK = 'NO', @KEEP_SRC_TABLE = 'YES', @FILEGROUP_NAME = 'PRIMARY', @FILLFACTOR = 95; EXECUTE inuser.IN_DB_UPGRADE_SP_SYNC_TABLE_IN_DOC @MAX_MINUTES = 10, @BATCH_SIZE = 100000; EXECUTE inuser.IN_DB_UPGRADE_SP_SYNC_REMOVE @TABLE_NAME = 'inuser.IN_DOC'; EXECUTE inuser.IN_DB_UPGRADE_SP_SYNC_RESET @TABLE_NAME = 'inuser.IN_DOC', @MAX_DOP = 4, @FILLFACTOR = 95; EXECUTE inuser.IN_DB_UPGRADE_SP_CREATE_INDEXES_IN_DOC @FILEGROUP_NAME = 'SECONDARY', @MAX_MINUTES = 30, @MAX_DOP = 4, @FILLFACTOR = 95; EXECUTE inuser.IN_DB_UPGRADE_SP_DOWNTIME_STEPS @MAX_DOP = 4;