You must run the appropriate incremental files for your database application and the current version of Perceptive Content Server. Follow the instructions appropriate for your RDBMS for running an incremental database upgrade script. A qualified DBA should perform this action. For more information on best practices for you database, refer to the Perceptive Content Best Practices for <database>.
Note: If you are updating an Oracle database you may choose to
delete and temporarily disable the Oracle recycle bin prior to running the upgrade
script. This prevents potential errors related to objects that exist in the recycle
bin.
- Click Start, and then click Run.
- In the Run dialog box, type cmd and then click OK.
- In the Command Prompt window, change to the [drive:]\inserver\bin directory.
- Run the following INTool command to view the incremental version of the database you are running: intool --cmd get-db-version
- In the Perceptive Content Server <database type> DB Creation and Updates Scripts Build <build number> file, apply each incremental file individually in order from the current version of your database to the latest incremental. ADD NOTE: Incremental-SS_6.6_to_6.7.0.2222.sql and later incrementals put the INOW6 database in SINGLE_USER mode while Snapshot Isolation and Row Versioning are enabled. The current upgrade connection remains active. The system stops, rolls back, and then disconnects any other connections to the database to complete the READ_COMMITED_SNAPSHOT command. The system returns the database to MULTI_USER mode and executes the rest of the script.