2. Using Ingres Commands : copydb Command--Copy and Restore a Database : copydb Example on VMS
 
Share this page                  
copydb Example on VMS
These commands make a static copy of olddb. In this example, replace the named default directory (mydir.backup) with your own:
createdb newdb
set default [mydir.backup]
copydb olddb
sql olddb <copy.out
Next, the following commands make a copy backup of olddb into newdb. In this example, replace the named default directory (mydir.backup) with your own:
set default [mydir.backup]
sql newdb <copy.in
sysmod newdb