SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-24
Moving a Database to a Different Node or Different
Volumes
Moving a Database to a Different Node or
Different Volumes
Moving a database involves moving a set of SQL objects from one environment to
another. This move might be of database objects from one group to another group or of
an entire database from one node (system) to another node.
This discussion examines a scenario where you want to move a complete grouping of
SQL objects defined in one or more catalogs. Suppose that you also want the
database to retain the same consistent state in the new location as it has in the old
location.
Choosing a Method
You might choose the DUP method or the BACKUP/RESTORE method of moving
objects. Your choice depends on the location of the two environments and the available
media for transfer.
You might choose the BACKUP/RESTORE method in these cases:
•
The target volumes do not have enough space to maintain two copies of the
objects at the same time. DUP requires both objects to be online simultaneously
until the operation is complete.
•
The source and target locations are not physically connected.
•
You want to maintain a backup copy of the database on tape media.
•
The database objects might need to be restored multiple times; for example, the
database environments are released or moved to a group to do testing or
documentation. The tape method gives you an archive copy so you can restore the
database many times to the same consistent state.
If you have SQL programs stored in OSS files in your database, use OSS utilities to
move these programs separately and then recompile them on the new node. For more
information about OSS utilities, see the Open System Services Shell and Utilities
Reference Manual.
Moving databases can be very complicated if the database files and catalog layout is
intricate. You must also have the proper read authority to the source objects and
catalogs, and you must have write authority to the target catalogs.