1. Initiation
Initiation is the data- or fact-gathering stage. It is concerned with investigating and documenting the current installation, which includes identifying all existing instances of OpenROAD, and gathering and documenting the requirements for the new environments.
Record any settings relevant to the existing OpenROAD installation. The migration test area should correspond as closely as possible to the live deployment environment, as should the development area setup to recompile and image OpenROAD in a 12.0 environment. The following checklist may be helpful in creating a proper test environment. These elements—or their absence—will impact the speed and success of your migration.
• OpenROAD installation (local or file-served). This includes:
– Ingres and operating system environment variables
– ingres\files area (especially config.dat and appedtt.ff, apped.ctb, and any variants)
– ingres\w4glapps area (all referenced application images)
– Any globals redefinition files
– Any other files and file areas that applications reference (including 3GL library files, registered where necessary), with appropriate permissions
• A test database with test data that closely tracks production data, configured to match the live database (including any II_EMBED_SET or ING_SET settings). If you are copying the data using copydb, ensure that any contents of II_STORED_STRINGS and II_STORED_BITMAPS are copied as well.
• Ingres Net nodes (redirected to up-to-date test or training databases)
• Startup and other batch files (amended to reference the relevant databases, file systems, and so on, redirected as appropriate)
• Shortcuts (as these may contain explicit parameters or settings)
• User accounts, passwords, and permissions necessary to run the applications successfully
• Network connectivity (where it affects OpenROAD application use)
• Operating system, drivers, and settings (monitor, regional, and language settings in particular)
• Citrix settings, where applicable
• Any referenced non-Ingres software, where its absence may prevent navigating to or displaying parts of the OpenROAD application
• A display monitor set to client specifications
Ensure that you can access this test environment through an account with sufficient permissions to issue commands such as ingsetenv.
Determine and establish the roles and necessary skills required for the migration and ascertain the availability of the necessary people on the migration team.
Team members should establish and agree upon any expectations or mandatory requirements for the migration. For example, your business may have set certain performance targets or expectations as to when the migration should be in place. Incorporate these into your plan.
After this initiation process, the scope of the migration should be clear. Add all these elements to the plan as outlined in
6. Plan Creation.
Required Installations for Migrating
For a safe and orderly migration, at least four OpenROAD installations are needed:
• Original version of the production installation
• Original version of the development installation
• New version of the development installation for preparing and testing applications
If possible, keep the installations away from the production machine. You may temporarily need additional hardware to accommodate the required installations during the migration.
Possible Hardware Setups for Migrating
A four-machine setup can be used, with each installation on its own machine. More commonly, however, the two development installations will share a machine. Because there is usually some traffic between these two installations during preparation, sharing a machine is convenient.
The current OpenROAD version and the new OpenROAD version Development and Runtime features can reside on the same machine when installed into separate Ingres instances.
It is possible to deploy two different versions of the OpenROAD eClient runtime on the same machine. Configure each eClient application to select which version of the eClient runtime to use.
The OpenROAD Server for the current and new versions of OpenROAD need environment variables that are set at the Windows system level. You may install only one instance of the OpenROAD Server per machine.
Two versions of the OpenROAD client can access the same OpenROAD Server instance. The “Install or Uninstall OpenROAD Server” shortcut will launch the ASREG utility. This utility:
• Installs a new OpenROAD Server if one does not exist.
• Migrates an existing OpenROAD Server to a new OpenROAD Server version.
The new OpenROAD Server can run OpenROAD 4GL image files on earlier versions. The OpenROAD Server version cannot run OpenROAD 4GL image files from a later release.
Note: There is no remote installation procedure for OpenROAD. The machine must have local media support; otherwise, you will need to copy the distribution files from wherever they were installed.