This step is required only if you are upgrading an existing version of ExtraView. If you are performing a new installation, you will have been provided with a database backup file that you will import into your Database installation instead. You can skip to the section that matches your selected Database – Oracle, SQL Server, or MySQL Database Configuration now.
You must backup your database before performing this step. ExtraView Corporation cannot guarantee that upgrades will complete successfully, therefore it is essential that you are able to revert to your existing installation.
You should take a full export of your database before running any of the following upgrade scripts. This will allow you to roll back to the previous version of ExtraView if there are any problems arising from the upgrade. Edit the following file:
C:\ExtraView\Tomcat7\webapps\ev\jWEB-INF\data\runWindows.bat
Replace the following lines with the appropriate values for your system:
runPatches.bat C:\ExtraView\jre7-67 C:\ExtraView\Tomcat7 C:\ExtraView\Tomcat7\webapps\evj
Replace C\:ExtraView\jre7-67 with your path to your Java
Replace C:\ExtraView\Tomcat7 with your path to your Tomcat
Replace C:\ExtraView\Tomcat7\webapps\evj with your path to your evj folder.
Now save and exit from the editor.
To upgrade the database, now run runWindows.bat from a Windows/DOS Command line so that you can monitor the progress of the upgrade.
The upgrade process initiated by the above command looks at your installation to determine exactly which version of code and which version of the database schema is active. The process will then apply all the patches to bring your system up to the current level. Some patches are very simple, some are more complex, and the time taken is dependent on the amount of data in your database.
As the individual patches are applied, you will see many lines of text scroll past on the screen. At some point, depending on the amount of data in your system, the patches may appear to “hang” while they perform large operations on the database – allow a reasonable amount of time (possibly 20 minutes or more) before you assume there is a problem with any individual part of the upgrade process. If you have any questions, please contact ExtraView Corporation.
Once the script has finished running, and you are returned back to a command prompt, and your upgrade to the database is complete.
For your reference, there is a log of the changes made to the database in the directory named C:\ExtraView\Tomcat7\webapps\ev\jWEB-INF\logs. These are held in a .log file (the exact name is specified in the Configuration.properties file). It is recommended that you save that file until you have verified your upgrade, so that the ExtraView Support can review this with you if you run into any issues. You can look through the log file to observe if any errors were generated during the upgrade process.
Oracle Database Upgrade Requirements
This step is only required if you are running Oracle as your database. ExtraView has been affected by bugs in a number of Oracle releases. If you are running a version of Oracle prior to Oracle 11.2.0.2, you should upgrade your installation. If you have access to Oracle Metalink, you should download the patch set from there. If not, ExtraView Corporation can provide you with information on how to retrieve the appropriate patch set.
Microsoft SQL Server Database Upgrade Requirements
This step is only required if you are running SQL Server as your database. ExtraView now requires SQL Server 2008 or later. If you are running an earlier version, you must upgrade your software.
MySQL Database Upgrade Requirements
This step is only required if you are running MySQL as your database. ExtraView now requires MySQL 5.6. If you are running an earlier version, you must upgrade your software.