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
ix
About This Manual
This manual explains how to migrate NonStop SQL/MP databases and applications on
a NonStop system to NonStop SQL/MX. NonStop SQL/MX is a relational database
management system for the HP NonStop server and is based on the ANSI/ISO/IEC
9075:1999 SQL standard, commonly referred to as SQL:1999.
Throughout this manual, SQL/MX Release 3.0, which is the latest version of SQL/MX,
is used for reference.
Audience
This manual is intended for database administrators (DBAs), HP support personnel,
and others who plan to migrate or upgrade databases and database applications to
NonStop SQL/MX. This manual addresses migration from SQL/MP to SQL/MX.
What This Manual Does Not Cover

Migration from other database vendors to NonStop SQL/MX. For assistance,
contact your service provider. For more information, see Assistance With Migration
on page 1-15.

Migration of SQL/MX, SQL/MP, and Enscribe databases and applications from an
HP NonStop S-series system to an HP Integrity NonStop NS-series system. For
more information, see the NonStop NS-Series Database Migration Guide.

Migration from Enscribe databases and applications to NonStop SQL/MX. An
automated tool to convert Enscribe databases and applications to NonStop
SQL/MX does not exist. The Escort SQL product converts Enscribe databases and
applications to NonStop SQL/MP. For more information, see the ESCORT SQL™
User’s Guide, which you can obtain from Carr Scott Software Inc. at
http://www.carrscott.com/evaluation_prog.shtml
. If there is sufficient market
demand, Carr Scott Software Inc. might modify Escort SQL to support direct
Enscribe-to-SQL/MX migrations. If you or your customer deems this functionality to
be critical to your project, send a note and background on the project to
[e-mail].

Migration to Format 2 SQL/MP tables. For more information, see the SQL/MP
Installation and Management Guide.