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

Overview of SQL/MX Migration
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
1-8
Risks of Different Migration Paths
Table 1-2. Risks of Different Migration Paths
Migration Path Undesired Consequences Migration Risk
1. Migrating SQL/MP database
objects to SQL/MX
database objects
Downtime when migrating database
objects and all applications
dependent on them
2. Migrating SQL/MP
applications to SQL/MX
applications
Downtime when migrating
applications
3. Migrating from SQL/MX
Release 1.8 to SQL/MX
Release 2.x
Downtime when upgrading the
system to SQL/MX Release 2.x; no
automatic way of falling back the
migrated metadata
4. Upgrading to a newer
SQL/MX release
Downtime when upgrading the
system to SQL/MX Release 2.x;
minimal changes to existing
applications; no changes necessary
to the database
5. Coexistence of NonStop
SQL/MP and NonStop
SQL/MX
No downtime involved when creating
new SQL/MX applications and
SQL/MX database objects; no
disruption to existing applications and
databases
Higher
Lower