Launching the Conversion Program

The OpenInsight 10 IDE from the STAR application.

At this point, type the command “EXEC RTI_MIGRATE_V9_TO_V10” in the TCL line at the top of the IDE. Click on the Execute button. Since we are in the application STAR, the Migrate OpenInsight Application tool will ONLY convert the OpenInsight v9 application with the same name.

The Migrate OpenInsight Application will display. The first migration task is to select the location of the OpenInsight v9 application your wish to migrate.

Click the Browse button to display a dialog box asking you to choose the folder that contains the OpenInsight v9 application you wish to convert. Browse to that folder, and then click on the OK Button.

Once you click on OK, the conversion program will interrogate the OpenInsight at that location, and determine what applications exist there.

If the application you are logged in as in OpenInsight v10 (in this case MYAPP) does not exist in the target OpenInsight v9, the migration process will not continue.

The migration tool will display the attached volumes for the application to be converted. The DATAVOL and REVBOOT folders cannot be copied.

The DATAVOL and REBVOOT volumes contain system information that cannot be copied from other instances of OpenInsight into the new OpenInsight 10 system. If you have application-specific tables in either the DATAVOL or REVBOOT volumes, we recommend that they be copied to either a new or already existing volume, and that the conversion process be run again.

For each Location to be migrated, choose and action to be performed. The choices are: Attach, Copy (OS), Copy (LH) or Move.

An explanation of the options:

An Operating System-level move of data to same relative path, from the previous OpenInsight v9 to the OpenInsight v10.

The data is moved from a folder relative to the existing application, to the same relative path to the new OpenInsight v10, so it is not necessary to specify the entire path – it will be created relative to the new OpenInsight Application. So, in the example below, the conversion program will make the STAR_DATA folder selected in the example above, just below the OInsight10 folder seen below.

This option is self-explanatory. The data stays where it currently resides, and will be attached by the OpenInsight v10 Application.

Copying the data offers two additional options: Either an Operating system level copy, or a Linear Hash level copy, as seen below.

An operating system-level copy of data from one or more folders to another set of folders, not affecting the original data, just copying it.

When choosing the ‘Copy’ option, the user is presented with a dialog box of the locations to be copied, as seen below.

The data is copied from a folder relative to the existing Application, to the same relative path to the new OpenInsight v10, so it is not necessary to specify the entire path – it will be created relative to the new OpenInsight Application. So, in the example below, the conversion program will make the STAR_DATA folder selected in the example above, just below the OInsight10 folder seen below.

The LH Copy option is an OpenInsight-based, Linear Hash table copy of the data, which will examine the original data and resize the target folders based upon scanning results. This will make the data table perform better in the OpenInsight v10 Application. If there are any Relational Indexes on the tables, they are removed, and must be re-added later.

The LH Copy uses the enhanced features of the OpenInsight Copy_Table command. A new eleventh parameter was added to the command: bOptimize. When this is set to true, it triggers the new Get_LH_Info_LHStats function. Based upon the results returned by this function, it makes changes accordingly to the new table.

Specifically:

• Get_LH_Info_LHStats is called

• LH Ratio is determined

• Average record size is determined

• Frame Size is increased in chunks of 2K until larger than average record size or at 32K

• New table is made with new attributes

• Data is copied

The user, or developer should consider the state, age, and size of the tables that will be used in the OpenInsight v10 application.

After the Action for the data has been decided, the user must choose the location to Migrate To for the Action options of: Copy (OS), Copy (LH) or Move. For the Action items Copy, the folder MUST exist prior to starting the conversion.

Here we are creating the new folder STAR_DATA under the C:\Revsoft\OInsight10 directory.

In the above example we doing an Action of Copy (OS) of the STAR_DATA volume and copying the files to C:\Revsoft\OInsight10\STAR_DATA. Select all the volumes you want to convert and then click the Next button to continue.

After click the Next button, the migration process will begin and the Migration Tasks will be reflected in the left panel of the tool.

Upon completion of the Migration OpenInsight Application process the conversion logs can be reviewed.

Click the View Errors button to view the error log. The error log is a text document located in your local Documents folder.

The Migration_Errors log.

Click the View Log button to view the migration log. The migration log is a text document located in your local Documents folder.

At this point, the process is complete. If there are errors, they can be corrected, and the conversion process can be run over and over again, as many times as is necessary. The next step in the conversion process is to add and attach your data tables.

From the OpenInsight v10 IDE go to View, Tool Panels, Database to launch the Database Tool Panel.

At this point in the migration process your data tables need to be added and attached to your application. Click the Add Tables button on the top of the Database Tool Panel.

Enter the path (for relative folders just enter the folder name) or browse to the location of the data tables. The Available Tables will be displayed. Select the tables you want to add to this application.

Click the Apply button to proceed.

Once your tables have been added, click Yes to update the database image. This will update the application DBT file.

Your data tables are now accessible via the Database Tool Panel. At this point you can add back any indexes or MFS that had been previously removed.

From the OpenInsight v10 IDE go to Tools, Launch Application to start your application.

The converted MDI frame has been launched.

The application forms have been automatically converted.

The Migrate OpenInsight Application tool will convert the Users from your existing OpenInsight v9 application. It will be necessary to update the passwords for each user except the default application user.

From the OpenInsight v10 IDE, got to Settings, Users, User Setup.

Enter New Password that conforms to the policy in force for each user.

After all accounts have been imported to your new OpenInsight 10.0 system, please go to the System Monitor in SYSPROG and type in the following:

O4WUPGRADE

You need only run this command one time, in SYSPROG, for all O4W configuration files to be upgraded.

This will upgrade all your O4W 9.x configuration files to match the settings required for OI/O4W 10.0. In particular, this will change your O4W configuration settings to use the latest jQuery and jQuery Mobile libraries that O4W supports. If you intentionally and explicitly wish (or need) to use different version(s) of the jQuery files, please re-set the local configuration files in your applications after running O4WUPGRADE.