SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001
v
About This Manual
This manual explains how to migrate databases and applications from SQL/MX
Release 2.3.x and SQL/MX Release 3.0 to SQL/MX Release 3.1, and how to manage
different versions of 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, references to SQL/MX Release 2.x indicate SQL/MX Release
2.0, SQL/MX Release 2.1, SQL/MX Release 2.2, and subsequent releases until
otherwise indicated in a replacement publication.
Audience
This manual is intended for database administrators (DBAs), HP support personnel,
and others who plan to migrate or upgrade databases and database applications from
SQL/MX Release 2.3.x and SQL/MX Release 3.0 to SQL/MX Release 3.1.
What This Manual Does Not Cover

Migration from NonStop SQL/MP to NonStop SQL/MX.

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-3.

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 consider modifying 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.