Before running the WorkView Schema Migrator, it is important to back up your database and to contact your first line of support to ensure that all prerequisites have been met. You should then upgrade to OnBase Foundation 22.1 immediately after running the WorkView Schema Migrator.
If you are upgrading from a version of OnBase prior to OnBase 14, you must run the WorkView Schema Migrator.
The WorkView Schema Migrator must be run as an administrator.
To run the migrator:
- Double-click on the WorkviewSchemaMigrator.exe file. If you do not have this file, contact Technical Support.
- Select the Datasource for the database you are upgrading from the drop-down list.
- Enter the Password for the database’s HSI user.
- Click Migrate the WorkView schema button.
- A message stating Your WorkView schema has been updated properly will display upon a successful migration. Click OK once the migration is complete.
- If any errors are logged, contact Technical Support.
The WorkView Schema Migrator does not support the ODBC Driver 11 for SQL Server.
If the migration does not complete in 45 minutes, the WorkView Schema Migrator must be run from the command line with the command of “WorkViewSchemaMigrator.exe –T<time>” where <time> is the total time in minutes. In the following examples, the migration will run for at least 120 minutes before timing out: “C:\OnBase\WorkViewSchemaMigrator\WorkViewSchemaMigrator.exe –T120”