NonStop NS-Series Database Migration Guide

HP Integrity NonStop NS-Series Database Migration Guide—540469-001
2-1
2
Migrating an SQL/MP or SQL/MX
Database
•
Migrating SQL/MX Release 1.8 to SQL/MX Release 2.x on page 2-1
•
Installing NonStop SQL/MP or NonStop SQL/MX on the New System on page 2-1
•
SQL/MX Interoperability Between Systems on page 2-2
•
Migration by Online Database Replication on page 2-2
•
Migration by Physically Disconnecting and Reconnecting Disk Storage Devices on
page 2-5
•
Migration by Using ALTER TABLE MOVE and ALTER INDEX MOVE Statements
on page 2-11
•
Migration by Using the BACKUP/RESTORE and Backup and Restore 2 Utilities on
page 2-15
•
Migration by Using SQLCI DUP and MXCI DUP on page 2-18
Migrating SQL/MX Release 1.8 to SQL/MX
Release 2.x
If you want to migrate from SQL/MX Release 1.8 to SQL/MX Release 2.x as part of
your database migration from a NonStop S-series system to an Integrity NonStop
NS-series system, you should migrate to SQL/MX Release 2.x on the NonStop
S-series system before you move your database to the new system.
For instructions about migrating from SQL/MX Release 1.8 to SQL/MX Release 2.x,
see the SQL/MX Database and Application Migration Guide.
Installing NonStop SQL/MP or NonStop
SQL/MX on the New System
Before you move data from the NonStop S-series system to the Integrity NonStop
NS-series system, install NonStop SQL/MP or NonStop SQL/MX on the new system:
Caution. Migrating a database from a NonStop S-series system to an Integrity NonStop
NS-series system is a complex endeavor. The steps in this subsection provide a general
overview of how to migrate a database using several tools. For assistance in migrating your
database, consult HP migration services. For information about these services, see Using HP
Migration Services on page 1-1.