NonStop NS-Series Database Migration Guide

Migrating an SQL/MP or SQL/MX Database
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
2-16
Steps for Moving an SQL/MP Database Using the
BACKUP/RESTORE Utilities
Steps for Moving an SQL/MP Database Using the
BACKUP/RESTORE Utilities
1. From the NonStop S-series system, query the CATALOGS table to determine the
names of the SQL catalogs to be moved.
2. From the NonStop S-series system, stop all applications that access the SQL/MP
database for the duration of the BACKUP operations.
3. Determine the names of the SQL objects involved in the move by querying the
catalogs identified in Step 1.
4. From the NonStop S-series system, identify database object dependencies by
using the DISPLAY USE OF command or by using catalog queries.
5. From the NonStop S-series system, perform the BACKUP command using the
FROM CATALOG qualifier to include base tables and catalog tables, individual
partitions of base tables and indexes, and SQL/MP shorthand views.
6. Move the magnetic tape that contains the backed up files to the Integrity NonStop
NS-series system.
7. From the Integrity NonStop NS-series system, use the RESTORE command to
copy the database to the disks.
8. From the Integrity NonStop NS-series system, verify the status of the database by
using the VERIFY utility or by using catalog queries.
9. From the Integrity NonStop NS-series system, SQL compile the applications.
10. From the Integrity NonStop NS-series system, make new TMF online dumps of all
restored catalogs and audited objects.
Caution. Migrating a database from a NonStop S-series system to an Integrity NonStop
NS-series system is a complex endeavor. These steps provide a general overview of how to
migrate a database using the BACKUP/RESTORE utilities. For assistance in migrating your
database, consult HP migration services. For information about these services, see Using HP
Migration Services on page 1-1.