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

About This Manual
HP NonStop SQL/MX Database and Application Migration Guide540435-005
xiv
Organization
Organization
Section 1, Overview of SQL/MX
Migration
Defines migration terminology, describes
possible migration paths to NonStop SQL/MX,
provides planning considerations, and describes
where you can go for further assistance.
Part I, Upgrading and Maintaining Different Versions of NonStop SQL/MX
Section 2, Version Management
and Interoperability
Describes SQL/MX releases, interoperability of
SQL/MX releases, versions of SQL/MX software
components, query plan versioning, and
managing a mixed-node network.
Section 3, Upgrading to a Newer
Version of SQL/MX Release 2.x
Provides guidelines for upgrading to a newer
version of SQL/MX Release 2.x.
Section 4, Falling Back to an Earlier
Version of SQL/MX Release 2.x
Provides guidelines for downgrading to an earlier
version of SQL/MX Release 2.x.
Part II, Migrating From SQL/MX Release 1.8 to SQL/MX Release 2.x
Section 5, Preparing to Migrate
From SQL/MX Release 1.8 to
SQL/MX Release 2.x
Describes how to prepare for migrating from
SQL/MX Release 1.8 to SQL/MX Release 2.x.
Section 6, Migrating SQL/MP
Metadata From SQL/MX Release
1.8 to SQL/MX Release 2.x
Describes how to migrate SQL/MP metadata for
SQL/MP aliases, system defaults, ODBC/MX
(MXCS) metadata, and stored procedures to
SQL/MX Release 2.x.
Section 7, Migrating SQL/MX
Release 1.8 Applications to
SQL/MX Release 2.x
Describes how to migrate SQL/MX Release 1.8
applications to operate in an SQL/MX Release
2.x environment.
Section 8, Falling Back to SQL/MX
Release 1.8
Describes how to fall back from SQL/MX
Release 2.x to SQL/MX Release 1.8.
Part III, Migrating From NonStop SQL/MP to NonStop SQL/MX
Section 9, Preparing to Migrate
From NonStop SQL/MP to NonStop
SQL/MX
Describes how to prepare for migrating from
NonStop SQL/MP to NonStop SQL/MX.
Section 10, Converting SQL/MP
Applications to SQL/MX
Applications
Explains why you might want to convert SQL/MP
applications to SQL/MX applications and
describes how to convert SQL/MP applications to
SQL/MX applications by modifying the source
code, recompiling, optimizing, and moving the
application to production.
Section 11, Converting an SQL/MP
Database to SQL/MX Tables
Explains why you might want to convert an
SQL/MP database to SQL/MX tables and
describes the differences between SQL/MP and
SQL/MX databases and how to convert an
SQL/MP database to SQL/MX tables.
Section 12, Falling Back to NonStop
SQL/MP
Describes how to fall back from NonStop
SQL/MX to NonStop SQL/MP.