MX 3.0 Database and Application Migration Guide (H06.22+, J06.11+)

HP NonStop SQL/MX 2.3.x to SQL/MX 3.0 Database and Application Migration Guide—666210-002

About This Manual

This manual explains how to migrate databases and applications from NonStop

SQL/MX 2.3.x to NonStop SQL/MX Release 3.0 and how to manage different versions

of 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, 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

NonStop SQL/MX 2.3.x to NonStop SQL/MX 3.0.

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-4.



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 harry.scott@carrscott.com.



Migration to Format 2 SQL/MP tables. For more information, see the SQL/MP

Installation and Management Guide.