NonStop NS-Series Database Migration Guide

Contents
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
ii
2. Migrating an SQL/MP or SQL/MX Database
(continued)
2. Migrating an SQL/MP or SQL/MX Database (continued)
Migrating Disks Between Systems With the Same Name and Systems With
Different Names 2-6
Advantages and Disadvantages 2-6
Steps for Moving an SQL/MP Database by Physically Disconnecting and
Reconnecting Disk Storage Devices Between Systems With the Same
Name 2-7
Steps for Moving an SQL/MX Database by Physically Disconnecting and
Reconnecting Disk Storage Devices Between Systems Having the Same
Name 2-8
Steps for Moving an SQL/MP Database by Physically Disconnecting and
Reconnecting Disk Storage Devices Between Systems Having Different
Names 2-9
Additional Sources of Information 2-11
Migration by Using ALTER TABLE MOVE and ALTER INDEX MOVE
Statements 2-11
Advantages and Disadvantages 2-11
Steps for Moving an SQL/MP Database by Using ALTER TABLE MOVE and
ALTER INDEX MOVE Statements 2-12
Additional Sources of Information 2-15
Migration by Using the BACKUP/RESTORE and Backup and Restore 2 Utilities 2-15
Advantages and Disadvantages 2-15
Steps for Moving an SQL/MP Database Using the BACKUP/RESTORE
Utilities 2-16
Steps for Moving an SQL/MX Database Using Backup and Restore 2 2-17
Additional Sources of Information 2-17
Migration by Using SQLCI DUP and MXCI DUP 2-18
Using SQLCI DUP
2-18
Using MXCI DUP
2-18
Advantages and Disadvantages 2-18
Steps for Moving an SQL/MP Database Using SQLCI DUP 2-19
Steps for Moving an SQL/MX Database Using MXCI DUP 2-20
Additional Sources of Information 2-20
3. Migrating an Enscribe Database
Converting Enscribe Data and Applications to SQL/MP on the New System 3-1
Converting Enscribe Data and Applications to SQL/MX on the New System 3-2
Converting DDL Dictionaries for Enscribe Applications on the New System 3-2
Overview of DDL Dictionaries for Enscribe Applications 3-2
DDL Compiler Problem Symptoms 3-3
Example: Converting a DDL Dictionary 3-3