SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Preparing to Migrate From SQL/MX Release 1.8 to

SQL/MX Release 2.x

HP NonStop SQL/MX Database and Application Migration Guide—540435-005

5-4

Keeping SQL/MP Metadata Tables

If you are migrating to SQL/MX Release 2.x from SQL/MX Release 1.8, do not delete

the SQL/MP metadata tables until you are sure you do not need to fall back. Deleting

these metadata tables prevents a successful fallback.

Ordering the Latest Supported Version of

SQL/MX Release 2.x

Order the latest version of SQL/MX Release 2.x that is supported by the RVU of the

system. For more information, see NonStop SQL/MX Releases

on page 2-2 and RVUs

and Supported SQL/MX Releases on page 2-7.

Be aware that installing an SQL/MX release on your system overwrites the previous

SQL/MX release. Although NonStop SQL/MP and NonStop SQL/MX can reside on the

same node, only one release of SQL/MX software can reside on a node at a time. For

example, if SQL/MX Release 2.2 is installed on a node, SQL/MX Release 2.0 or

SQL/MX Release 1.8 cannot be installed at the same time.

Ordering Corequisite Independent Products

Order any corequisite independent products for the version of SQL/MX Release 2.x

that you install on your system. Some corequisite independent products include:

•

RDF

•

NonStop Server for Java

•

JDBC Driver for SQL/MX

For more information, see the

H06.nn or G06.nn Release Version Update

Compendium.

Preparing for Metadata Migration

Migration from SQL/MX Release 1.8 to SQL/MX Release 2.x is largely a manual

process. No tool is available that can perform all the migration steps from start to finish.

However, the

migrate utility automates the process of migrating certain SQL/MX

Release 1.8 metadata. For more information, see Section 6, Migrating SQL/MP

Metadata From SQL/MX Release 1.8 to SQL/MX Release 2.x.

For SQL/MP tables used with SQL/MX Release 1.8, you must migrate certain

MPALIAS metadata elements before you can use these tables with SQL/MX Release

2.x. To migrate MPALIAS metadata using the

migrate utility, see Steps for Migrating

MPALIAS Metadata to SQL/MX Release 2.x on page 6-5.