The IN_DB_UTIL package is a collection of integrated procedures and functions that perform common database tasks that were previously part of the database incremental scripts. The IN_DB_UPGRADE package depends on the IN_DB_UTIL package.
To create the various IN_DB_UTIL database functions and stored procedures used by the upgrade package, complete one of the following options.
Note: Make sure you are connected to the correct database and the
v_database_name variable matches the database name you are
upgrading.
-- Name of Database :setvar v_database_name 'INOW'
In SSMS, execute the following script.
PerceptiveContentDB_IN_DB_UTIL_SQLServer_Package_v5.0.sql
Using the sqlcmd utility, execute the following script.
sqlcmd -I -i "PerceptiveContentDB_IN_DB_UTIL_SQLServer_Package_v5.0.sql"
Note: You must establish your connection using the -l option to set
the QUOTED IDENTIFIER connection option to ON. The default is OFF.
Example:
set SQLCMDSERVER=[protocol:]server[\instance_name][,port] set SQLCMDDBNAME=[DBNAME] sqlcmd -I -i "PerceptiveContentDB_IN_DB_UTIL_SQLServer_Package_v5.0.sql"