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-18

Migration by Using SQLCI DUP and MXCI DUP

Using SQLCI DUP

You can use SQLCI DUP to duplicate individual SQL/MP objects (for example, a table,

index, view, or an SQL program stored in a Guardian file) from one node to another,

interactively, when the nodes are connected in a network and the requesting user ID

has the appropriate remote security to allow the transfer. Usually the dependent

objects (shorthand and protection views, and indexes) are moved with the underlying

table or tables. Constraints are automatically moved with a table.

You can move audited and nonaudited objects by using DUP. You cannot perform a

DUP operation within a user-defined TMF transaction. If the source object is audited,

the DUP command completes the DUP operation on a nonaudited target object and

then automatically changes the AUDIT attribute to AUDIT as the operation completes.

BACKUP and RESTORE can move audited files by using the AUDITED option in the

same manner as DUP. After using DUP or RESTORE, you must make TMF online

dumps of all restored audited objects to create a new recovery point.

Using MXCI DUP

You can use MXCI DUP to duplicate individual SQL/MX tables from one node to

another, interactively, when the nodes are connected in a network and the requesting

user ID has the appropriate remote security to allow the transfer. Indexes and some

types of constraints are automatically moved with a table.

MXCI DUP moves only audited objects. You cannot perform a DUP operation within a

user-defined TMF transaction. If the source object is audited, the DUP command

completes the DUP operation on a nonaudited target object and then automatically

changes the AUDIT attribute to AUDIT as the operation completes. After using DUP,

you must make TMF online dumps of all restored audited objects to create a new

recovery point.

Advantages and Disadvantages

Before choosing this method of migration, consider the advantages and disadvantages

of using SQLCI DUP and MXCI DUP as described in Table 2-5.

Note. DUP requires the source and target objects to be online simultaneously until the

operation is complete.

Note. DUP requires the source and target objects to be online simultaneously until the

operation is complete.