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-4
Steps for Moving an SQL/MX Database Using RDF
•
If you do not have sufficient disk space and prefer to use a high-speed,
high-bandwidth Expand network connection, create your empty database on
the Integrity NonStop NS-series system and use SQLCI LOAD commands with
the SHARE option to populate the empty database with the primary database
records over the network. For detailed instructions, see the procedures for
online database synchronization with SQL/MP 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 SQLCI LOAD 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.
Steps for Moving an SQL/MX Database Using RDF
1. Determine exactly which data from the SQL/MX database on the NonStop S-series
system you want to replicate to the Integrity Nonstop NS-series system.
2. Develop the scripts that will manually create empty files for an empty database and
that will load the files with that data.
3. From the NonStop S-series system, initialize, configure, and start RDF with
updating disabled (START RDF, UPDATE OFF).
4. Create and populate an empty version of the primary database:
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.
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 RDF. For assistance in migrating your database, consult HP
migration services. For information about these services, see Using HP Migration Services
on
page 1-1.
Note. This subsection contains a high-level overview of one method for migrating an SQL/MX
database using RDF. For detailed instructions about using RDF for online synchronization of
SQL/MX databases, see the HP NonStop RDF System Management Manual.
Note. To replicate nonaudited files, first use AutoTMF to convert them to audited files. To
replicate files that cannot be made audited (for example, object, edit, and OSS files), use
AutoSYNC to move them.