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-3
Steps for Moving an SQL/MP Database Using RDF
Steps for Moving an SQL/MP Database Using RDF
1. Determine exactly which data from the SQL/MP 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:
•
If you have enough disk space on your NonStop S-series system to hold a
copy of the primary database, load the primary database into the empty
database on the NonStop S-series system using SQLCI LOAD commands with
the SHARE option. Use the BACKUP/RESTORE utilities to move the duplicate
database from the NonStop S-series system to the Integrity NonStop
NS-series system. For detailed instructions, see the procedures for online
database synchronization with SQL/MP objects in the HP NonStop RDF
System Management Manual.
Table 2-1. Advantages and Disadvantages of Using RDF
Advantages Disadvantages
•
Allows for quick and reliable
online migration of large
databases.
•
After migration, you can
continue to maintain an
online copy of your
database on the NonStop
S-series system and
immediately make it your
fallback database if
necessary.
•
RDF requires that the copied database be identical
to the original database.
•
At least during migration, you must maintain copies
of the same database on the source system and the
target system.
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/MP
database using RDF. For detailed instructions about using RDF for online synchronization of
SQL/MP 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.