SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-28
Example of Moving a Database
PVIEW $DATA.PERSNL.EMPLIST TO
$DATA1.PERSNL.EMPLIST
INDEX $DATA.PERSNL.XEMPNAME TO
$DATA1.PERSNL.XEMPNAME
INDEX $DATA.PERSNL.XEMPDEPT TO
$DATA1.PERSNL.XEMPDEPT
DUPLICATED TABLE $DATA.PERSNL.JOB TO $DATA1.PERSNL.JOB
DUPLICATED TABLE $DATA.SALES.CUSTOMER TO
$DATA1.SALES.CUSTOMER
PVIEW $DATA.SALES.CUSTLIST TO
$DATA1.SALES.CUSTLIST
INDEX $DATA.SALES.XCUSTNAM TO
$DATA1.SALES.XCUSTNAM
DUPLICATED TABLE $DATA.SALES.ODETAIL TO $DATA1.SALES.ODETAIL
DUPLICATED TABLE $DATA.SALES.ORDERS TO $DATA1.SALES.ORDERS
INDEX $DATA.SALES.XORDREP TO $DATA1.SALES.XORDREP
INDEX $DATA.SALES.XORDCUS TO $DATA1.SALES.XORDCUS
DUPLICATED TABLE $DATA.SALES.PARTS TO $DATA1.SALES.PARTS
INDEX $DATA.SALES.XPARTDES TO
$DATA1.SALES.XPARTDES
SVIEW $DATA.INVENT.VIEW207 TO
$DATA1.INVENT.VIEW207
SVIEW $DATA.PERSNL.MGRLIST TO
$DATA1.PERSNL.MGRLIST
SVIEW $DATA.SALES.ORDREP TO $DATA1.SALES.ORDREP
26 OBJECT(S) DUPLICATED
catalog queries.
>> VERIFY $DATA1.INVENT.*;
... <-- omitted miscellaneous tables
--- Verifying $DATA1.INVENT.ERRORS
--- $DATA1.INVENT.ERRORS verified.
--- Verifying $DATA1.INVENT.PARTLOC
--- $DATA1.INVENT.PARTLOC verified.
--- Verifying $DATA1.INVENT.PARTSUPP
--- $DATA1.INVENT.PARTSUPP verified.
--- Verifying $DATA1.INVENT.SUPPLIER
--- $DATA1.INVENT.SUPPLIER verified.
--- Verifying $DATA1.INVENT.VIEW207
--- $DATA1.INVENT.VIEW207 verified.
--- Verifying $DATA1.INVENT.XSUPORD
--- $DATA1.INVENT.XSUPORD verified.
--- Verifying $DATA1.INVENT.XSUPPNAM
--- $DATA1.INVENT.XSUPPNAM verified.
--- SQL operation complete.
Example 9-1. Example of Moving the Sample Database (page 3 of 5)