SQL/MP to SQL/MX Database and Application Migration Guide

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
1-1
1 Overview
This chapter describes the guidelines and the plan to migrate from NonStop SQL/MP
to NonStop SQL/MX.
SQL/MX is the standards based-database for NonStop servers. NonStop SQL/MX
inherits the same performance and high-availability characteristics and provides a
familiar environment for SQL/MP database users by building on the features offered by
NonStop SQL/MP.
The following are some of the advantages offered by SQL/MX:

supports ANSI/ISO SQL:1999 standards

removes many limitations of NonStop SQL/MP

co-exists with NonStop SQL/MP

eliminates the need to convert data or applications from SQL/MP to SQL/MX

provides an MX-only environment to new users
This chapter discusses the following topics:

Migration Terminology on page 1-1

Migrating from NonStop SQL/MP to NonStop SQL/MX on page 1-2

Planning for Migration on page 1-4

Guidelines for Conducting the Migration on page 1-14

Assistance With Migration on page 1-15
Migration Terminology
You must be familiar with these terms, which are used throughout the manual:
Migration. Moving your database and applications from one database product to another,
such as migrating from NonStop SQL/MP to NonStop SQL/MX.
Fallback. Reverting from a newly installed database product to the previously installed
database product, such as falling back from NonStop SQL/MX to NonStop SQL/MP.
Version. A product version or the version of a software component.
Release. The term used to refer to the product version of NonStop SQL/MX. A SQL/MX
release identifies a set of SQL/MX products as belonging to a given version of NonStop
SQL/MX.
SQL/MP application. Uses SQL/MP syntax, is SQL-compiled using SQLCOMP, and can
query only SQL/MP database objects.