SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Migrating an SQL/MP Database to NonStop SQL/MX
Release 2.1 or Release 2.0
HP NonStop SQL/MX Installation and Management Guide—523723-004
14-4
Planning for Fallback
This approach effectively separates the installation phase from the feature
development and utilization phase. If fallback becomes necessary, it is most likely to
occur during the installation phase, before you have started using new features.
Planning for Fallback
It might be necessary to install fallback SPRs on the Release 1.8 system before
migrating to G06.23 (or a later RVU) and Release 2.1 or Release 2.0. These SPRs
ensure that you can return your system to its original state if something goes wrong
during or after the migration. For information about installing fallback SPRs, see
Preinstallation Tasks on page 3-1.
Migrating an SQL/MP Database to Release 2.1
or Release 2.0 Using MP Tables
To migrate SQL/MP tables that have been used either in an SQL/MP environment or in
a Release 1.8 environment to Release 2.1 or Release 2.0:
1. Plan for database migration, as described in Planning for Migration on page 14-2.
2. Use the procedures in Section 3, Installing NonStop SQL/MX to install Release 2.1
or Release 2.0 on nodes where the SQL/MP database resides.
3. Create or migrate metadata for the tables:
•
If the SQL/MP tables were used in an SQL/MP environment, you might need to
create SQL/MP aliases and system defaults for them in the Release 2.1 or
Release 2.0 environment. For more information, see:
°
Section 6, Reviewing and Setting System Defaults
°
The CREATE SQLMP ALIAS and INSERT INTO SYSTEM_DEFAULTS
information in the SQL/MX Reference Manual
•
If the SQL/MP tables were used in a Release 1.8 environment, you can use the
migrate utility to migrate metadata. See Migrating an Enscribe Database to
Release 2.1 or Release 2.0 Using SQL/MX Tables on page 14-14.
4. Work through your application migration issues. See Section 11, Managing
Database Applications.
Migrating an SQL/MP Database to Release 2.1
or Release 2.0 Using SQL/MX Tables
Use these steps to copy data from SQL/MP tables in an SQL/MP database into
SQL/MX tables. This procedure is facilitated by the fact that SQL/MP and SQL/MX
environments can reside on the same system.
1. Plan for database migration, as described in Planning for Migration on page 14-2.