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-3
Migrating From NonStop SQL/MP to NonStop
SQL/MX
information, see Section 6, Migrating SQL/MP Metadata From SQL/MX Release 1.8 to
SQL/MX Release 2.x. Some changes might be required to SQL/MX Release 1.8
applications in the SQL/MX Release 2.x environment. For more information, see
Section 7, Migrating SQL/MX Release 1.8 Applications to SQL/MX Release 2.x.
Migrating From NonStop SQL/MP to NonStop SQL/MX
If you are currently using NonStop SQL/MP, there are several paths of migrating to
NonStop SQL/MX:
•
Coexistence of NonStop SQL/MP and NonStop SQL/MX on page 1-3
•
Migrating SQL/MP Applications to NonStop SQL/MX on page 1-4
•
Migrating SQL/MP Database Objects to NonStop SQL/MX on page 1-5
•
Phased Versus Rapid Migration to NonStop SQL/MX on page 1-5
•
Migrating to a New Hardware Platform on page 1-6
To migrate from Nonstop SQL/MP to NonStop SQL/MX, see Part III, Migrating From
NonStop SQL/MP to NonStop SQL/MX.
Coexistence of NonStop SQL/MP and NonStop SQL/MX
If you want to use NonStop SQL/MX, you are not required to convert your existing
SQL/MP applications and database objects to NonStop SQL/MX. NonStop SQL/MX
and NonStop SQL/MP can run on the same NonStop system, at the same time,
sharing the same data. SQL/MX applications and databases can coexist with SQL/MP
applications and databases. Existing SQL/MP applications run unchanged while you
develop and deploy new SQL/MX applications.
On a system that has SQL/MX Release 2.x installed, you can create new SQL/MX
applications that:
•
Access existing SQL/MP tables
•
Access new SQL/MX tables
•
Access both SQL/MP and SQL/MX tables
•
Join data from SQL/MP and SQL/MX tables