Converting your database to v2.1
You will need to have a v2.0 database to convert. Refer to the v2.0 conversion help if you have a database used with an earlier than v2.0. The conversion process itself does not switch the database platform type: so if you have an Access database you convert to a v2.1 Access database, but you can use the Move/Copy database tool within StrataBugs to move the data to a new database platform if required. You may need to move the data to a new database if you are using Java 8 which does not support Access, you are running on 64-bit, or you want to share your database between the Windows PC and the Macintosh platform. Refer to the compatibility matrix for more information or contact us for advice.
The general procedure is to make a copy, or a backup copy, of the 2.0 database, then run the conversion script on this copy to create the database objects and dependencies that v2.1 requires. The database copy procedure will vary, depending on the database type. For Access databases you can simply copy the database file, but if you have a server based system like Oracle or SQL Server then your database administrator will need to do this.
Procedure
-
For an Access database, make a copy of the 2.0 database file. This will usually be a file called sbugs2-0.mdb in your v2.0 StrataBugs folder. Copy this file into the v2.1 data folder (or any other file location that is preferably included in your regular backup cycle), and rename the file so that it is called sbugs2-1.mdb.
-
Open the conversion program. This will be a file called SBconvert2_1.jar. You may be able to start this program by double-clicking the file, but for Access databases you will need to ensure that you are using the 32-bit version of Java7, so you should start the program from a Command Prompt window with the following command:
"C:\Program Files (x86)\java\jre7\bin\java" -jar SBConvert2_1.jar
-
You will need to create a v2.1 connection to your database. For Access, you will need an ODBC connection. Once the connection is configured, the conversion program will make a connection to your Access database and to the demo database (which is in H2 format, in the \Data folder). It needs to make the second connection to enable some default chart templates to be copied over from the demo database, at the time the "Create tables" step is run.
-
Once the main window of the conversion program is open, you have a command window in the upper half, and an output window in the lower half. Selecting the option buttons at the top will pre-select the commands to run.
-
For an Access database, press the "Prepare Access keys" option, then press Run. If this completes successfully, repeat for the "Create tables" and "Move data" options. If these all run without problems, then your database conversion is complete and you can close. When you open the main StrataBugs 2.1 control panel application, you can use the same connection setting to proceed to the StrataBugs 2.1 control panel.
-
If you get any errors during this process, contact us for advice, as your database might not be useable in v2.1.