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-4
Migrating From NonStop SQL/MP to NonStop
SQL/MX
Creating new SQL/MX applications and database objects poses less risk than
converting SQL/MP applications and database objects to NonStop SQL/MX. While
developing and deploying new SQL/MX applications and database objects, you can
continue to use SQL/MP applications and databases without disruption and downtime.
Migrating SQL/MP Applications to NonStop SQL/MX
You can convert SQL/MP applications to SQL/MX applications by changing the
SQL/MP syntax to SQL/MX syntax in the source code and by SQL-compiling with the
MXCMP compiler.
Figure 1-1. Coexistence of NonStop SQL/MP and NonStop SQL/MX
Figure 1-2. Migrating SQL/MP Applications to SQL/MX Applications
SQL/MP
Application
SQL/MX
Application
SQL/MX
database
SQL/MP
database
VST003.vsd
SQL/MX
Application
SQL/MX
database
SQL/MP
database
VST004.vsd
SQL/MP
Application
Migrating the application