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

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
6-1
6
Migrating SQL/MP Metadata From
SQL/MX Release 1.8 to SQL/MX
Release 2.x
Because SQL/MX Release 1.8 does not have SQL/MX database objects, SQL/MX
Release 1.8 stores the metadata of these database entities in SQL/MP user metadata
tables:
•
SQL/MP aliases
•
System defaults
•
ODBC/MX (MXCS) metadata
•
Stored procedures in Java (SPJs)
When migrating from SQL/MX Release 1.8 to SQL/MX Release 2.x, use the
migrate
utility to migrate the metadata from SQL/MP user metadata tables to SQL/MX Release
2.x system metadata tables. Follow these guidelines:
•
System Requirements for Migrating SQL/MP Metadata on page 6-2
•
Steps Before Migrating SQL/MP Metadata on page 6-2
•
Considerations for Falling Back From SQL/MX Release 2.x on page 6-3
•
The migrate Utility on page 6-3
•
Overview of Metadata Migration Using the migrate Utility on page 6-4
•
Steps for Migrating MPALIAS Metadata to SQL/MX Release 2.x on page 6-5
•
Steps for Migrating DEFAULTS Metadata to SQL/MX Release 2.x on page 6-8
•
Steps for Migrating ODBC/MX Metadata to SQL/MX Release 2.x on page 6-10
•
Steps for Migrating PROCS and PARAMS Metadata to SQL/MX Release 2.x on
page 6-11
Use the
migrate utility immediately after installing SQL/MX Release 2.x, after creating
the catalogs and schemas in the SQL/MX Release 2.x database, and before migrating
SQL/MX Release 1.8 applications. If you do not use SQL/MP aliases, system defaults,
ODBC/MX (MXCS) metadata, or SPJs in your SQL/MX Release 1.8 database, skip this
section and proceed to Section 7, Migrating SQL/MX Release 1.8 Applications to
SQL/MX Release 2.x.