Introduction
When updating customer databases to 2.1.x from versions predating 1.6.4 there can be database errors and missing tables that can cause issues during or after the upgrade. To get around these potential issues it is necessary to upgrade the database to version 1.6.4 before completing the database upgrade to 2.1.x. Best observed practice is that any database version previous of 1.6.4 u 29 should be upgraded to 1.6.4 u 29 before finishing the upgrade to 2.1.x.
Below is a visual representation of the idea database upgrade process
Performing this can be accomplished by swapping 2 files from the 1.6.4 DBManager into the Manitou directory. After the 1.6.4 upgrade is complete the files can be reverted to run the 2.1.x DBMmanager and complete the uprgrade. This severely lessens the amount of time required to change between DBManager Versions.
Preparation
To facilitate the fastest swap between file versions requires the technician to possess both the older version and new version of the DBManager files.
As a first step the Manitou Directory should be updated to the Current Patch with package 2 and 1 deployed at a minimum. This will provide the most up to date DBManager files that will be used to completed the 2.1.x upgrade.
For the 1.6.4 u 29 DBM Files download the attached .zip folder on this document. This possesses the 2x DBM Files and a 1.6.4 u 29 Database Schema file.
To prep the Files for easiest operation follow the steps below:
This should result in the 2 folders containing the following files:
Changing DBManager Versions
Now that the two folders have been created and populated with the appropriate files it is now possible to switch between either version of the DBManager. To change between versions follow the instructions below.
1.6.4 DBManager Downgrade:
- Close any open DBManager applications
- Open the DBM Files 1.6.4 folder
- Select the following files:
- DBMANAGER.EXE
- MANITOU.DATABASEMIGRATIONS.DLL
- Copy these files into the %/Program Files (x86)/Bold Technologies/Manitou directory
- Approve the prompt to Replace Existing Files
- Launch theDBManager application from Desktop shortcut as an Administrator
2.1. u X DBMnanager Restore/Upgrade:
- Close any open DBManager applications
- Open the DBM Files 2.1 folder
- Select the following files:
- DBMANAGER.EXE
- MANITOU.DATABASEMIGRATIONS.DLL
- Copy these files into the %/Program Files (x86)/Bold Technologies/Manitou directory
- Approve the prompt to Replace Existing Files
- Launch DBManager application from Desktop shortcut as an Administrator
Functional Process to upgrade Database from Sub-1.6.4 u 29 Versions
The following steps will highlight the approved process for upgrading a customer Database from Sub-1.6.4 u 29 versions. A short addition for early DB versions will also be included. Documentation for 1.5.x and early 1.6.x version exists separately. Follow those approved processes before performing this upgrade process if necessary.
- Upgrade Database to version 1.6.3 or better following approved processes already in place
- Downgrade the DBManager to 1.6.4 version using the above process
- Open the appropriate Configuration File for the DBManager already created on the server, or create one if necessary.
- Select the Database Updates tab on the left
- Select the appropriate Database from the drop-down menu
- Verify the Database Update Type is 1.6.4.x version
- Select Apply to run the Database Update
- When the update is complete the Apply button will re-appear
- Select the Health Check tab on the left
- Select the appropriate Database from the drop-down menu
- Click the Magnifying glass in the Schema File field.
- Select the 1.6.4 Manitou_Schema file that is located in %/Program Files (x86)/Bold Technologies/Manitou/DBM Files 1.6.4/
- Select Check Database to perform the Health Check
- After all entries have populated, select all entires
- Filter by remove table and un-check all RemoveTable entries
- Filter by remove index and un-check all Remove Index entries
- Remove filtering to again show All items
- Select Apply Changes to complete the approved functions
- Wait for the health check to complete
- Select Check Database and verify the only entries remaining are the Remove Entries that were excluded earlier
- If any non-removal entries are present, select and apply them
- Close the DBManager Application
- Perform the above process to restore the DBManager application to it's 2.1 u X versioning
- Open the same configuration file used earlier with the 1.6.4. DBManager
- Select the Database Updates tab on the left
- Select the appropriate Database from the drop-down menu
- Verify the Database Update Type is 2.1.x version
- Select Apply to run the Database Update
- When the update is complete the Apply button will re-appear
- Select the Health Check tab on the left
- Select the appropriate Database from the drop-down menu
- Click the Magnifying glass in the Schema File field.
- Select the current Manitou_Schema file that is located in %/Program Files (x86)/Bold Technologies/Manitou/Distributer/(Current Patch #)/
- Select Check Database to perform the Health Check
- After all entries have populated, select all entires
- Filter by remove table and un-check all Remove Table entries
- Filter by remove index and un-check all Remove Index entries
- Remove filtering to again show All items
- Select Apply Changes to complete the approved functions
- Wait for the health check to complete
- Select Check Database and verify the only entries remaining are the Removes that were excluded earlier
- If any non-removal entries are present, select and apply them
- Close the DBManager Application
Conclusion
After this process the target Database will have been upgraded successfully to 2.1 u X version. This process is necessary as the upgrade from sub-1.6.4 to 2.1 u X directly will fail or incur database issues that can cause unintended and unnecessary complications.
