SQL/MP Installation and Management Guide

Moving a Database

HP NonStop SQL/MP Installation and Management Guide—523353-004

9-4

DUP and BACKUP/RESTORE

The DUP utility duplicates objects from one location to another interactively. DUP can

move SQL objects from one node to another when the nodes are connected in a

network and the requesting user ID has the appropriate remote security to allow the

transfer.

The BACKUP and RESTORE utilities provide another method of moving SQL/MP

objects. You can use these utilities to move objects to another location on the same

node or to another node. BACKUP and RESTORE must be used in cases in which the

target node is not physically connected to the source node.

When you back up files, you specify a qualified file set to indicate the set of files to be

backed up. A qualified file-set list specifies a set of objects and files and optionally

includes clauses that restrict the objects and files operated on based on attributes of

the objects and files. For information about the syntax of a qualified file-set list, see the

“Qualified File-set List” entry in the SQL/MP Reference Manual or use the SQLCI

HELP command.

This list compares DUP with BACKUP/RESTORE:

•

The DUP and BACKUP/RESTORE utilities allow these options:

Using qualified file set lists and wild-card characters

Working with both SQL/MP objects and Enscribe files

Selecting options to keep or purge targets of the file set lists to prevent

duplication or overwriting

Continuing with an operation despite errors

Automatically moving comments and constraints to the target catalog of the

target table

•

DUP allows these options:

Saving current file information with the new file (the SAVEID, SOURCEDATE,

and SAVEALL options)

Choosing automatic duplication, explicit duplication, or no duplication for

protection and shorthand views

Choosing either automatic duplication or no duplication for dependent indexes

Duplicating the source object only when the command has exclusive use of the

object