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-5
Additional Sources of Information
•
If you have enough disk space on your NonStop S-series system to hold a
copy of the primary database:
°
Create temporary and permanent catalogs and schemas on the Integrity
NonStop NS-series system.
°
Use INSERT...SELECT statements to copy the primary SQL/MX database
into the empty database on the NonStop S-series system.
°
Back up the duplicate database and restore it on the Integrity NonStop
NS-series system.
For detailed instructions, see the procedures for online database
synchronization with SQL/MX objects in the HP NonStop RDF System
Management Manual.
•
If you do not have sufficient disk space and prefer to use a high-speed,
high-bandwidth Expand network connection, create the backup catalog,
schema, and objects on the Integrity NonStop NS-series system and populate
the backup objects there with the primary SQL/MX database objects. For
detailed instructions, see the procedures for online database synchronization
with SQL/MX objects in the HP NonStop RDF System Management Manual.
5. After the database copy is installed on the Integrity NonStop NS-series system,
start RDF updating. RDF reads the audit changes that have been made to the
primary database since the start of the INSERT...SELECT operations and applies
these changes to the backup database on the Integrity NonStop NS-series system.
When RDF finishes applying these audit trail changes, it reports that the primary
and backup databases are synchronized.
6. After you have completed testing and evaluating the backup database, make the
Integrity NonStop NS-series system the primary database and start running
production applications from it.
Additional Sources of Information
For detailed instructions about using RDF for online synchronization of SQL/MP and
SQL/MX databases, see the HP NonStop RDF System Management Manual.
Migration by Physically Disconnecting and
Reconnecting Disk Storage Devices
This method involves physically disconnecting your disk storage devices from a
NonStop S-series system and reconnecting them to your Integrity NonStop NS-series
system. You need to decide whether you want the old and new systems to have the
Note. While the Integrity NonStop NS-series system is the backup database, run only
read-only applications on that system to prevent any changes that are independent of the
primary database.