Step by step Instructions
These instructions are for upgrade on Linux/Unix. If you are running Windows, please substitute equivalent commands.
DB CAM is a web application and is distributed in the form of a war (Web Application Archive) file. The latest released version of the war file can be downloaded after logging into your account at www.dbcam.com.
The file name will have the following format :
dbcam-<major version>.<minor version>.<build number>.war
Please follow the following setps in order to perform the upgrade. This note assumes that you have originally performed the installation using the steps outlined in this article and are using tomcat as your web application server.
1. Place the Scheduler in Stand-by mode. See here for instructions. If there are any jobs in progress, please wait for them to complete before going to the next step.
2. Shut down the web application server.
$ cd $DBCAM_HOME
$ sh ./stop_tomcat.sh
3. Move existing ROOT directory to backup directory. Takes an export backup of the DB CAM schemas.
$ cd $DBCAM_HOME/tomcat7/webapps
$ mv ROOT <backup directory>
4. Create new ROOT directory and change directory to it.
$ mkdir ROOT
$ cd ROOT
5. Unzip the war file
$ unzip <war download dir>/dbcam-x.y.z.war
6. Restore the license and properties file (dbcam.lic & dbcam.properties) from the pre-upgrade directory tree that you backed up in Step 2. These file are located in $DBCAM_HOME/tomcat7/webapps/ROOT/WEB-INF/classes
7. Clean up old work/log directories and start tomcat server
$ rm -rf $DBCAM_HOME/tomcat7/work/*
$ rm -rf $DBCAM_HOME/tomcat7/logs/*
$ sh ./start_tomcat.sh
8. Open a browser and log into DB CAM as user - dbcam
9. Once you are logged in, you should see a link in red in the bottom bar that says 'METADATA OUT OF SYNC'. Click on this link. On the next page, click on the button "Check Repository". This will validate the database repository with the war file and list the changes that will be performed during the upgrade. This may take a few minutes to complete as it validates each table and its data, as the case may be.
If you do not see the 'METADATA OUT OF SYNC' message, that means the new war file is compatible with your existing repository and no changes are required to the metadata repository. The upgrade is complete and you do not need to perform any more steps.
10. The next screen will list the discrepancies found and the upgrade actions that will be performed. Click on the Upgrade Repository button to start the actual upgrade process.
11. If there are no errors, you will see a message saying that the metadata repository has been sync'ed and that the upgrade was successful. In addition, the 'METADATA OUT OF SYNC' message would have disappeared.
12. At this point, restart tomcat to finish the upgrade.
13. Resume the Scheduler and any paused Jobs.