Ingres 11.0 | Example: Copydb

Star User Guide > Star User Guide > Using a Distributed Database > Copying Objects Using copydb > Example: Copydb

Was this helpful?

Example: Copydb

The following example shows copydb used against a distributed database named distdbname and a coordinator database named iidistdbname:

UNIX:

cd /usr/mydir/iidistdbname
copydb iidistdbname
sql iidistdbname <copy.out

cd /usr/mydir/distdbname

copydb distdbname/star

createdb newdistdbname/star

cd /usr/mydir/iidistdbname

Edit copy.in to replace ’iidistdbname’ by ’iinewdistdbname’:

sql iinewdistdbname <copy.in

cd /usr/mydir/distdbname

Edit copy.in to replace ’distdbname’ by ’newdistdbname’:

sql newdistdbname <copy.in

VMS:

set def usr_disk:[mydir.iidistdbname]
copydb iidistdbname
sql iidistdbname <copy.out

set def usr_disk:[mydir.distdbname]
copydb distdbname/star

createdb newdistdbname/star

set def usr_disk:[mydir.iidistdbname]

Edit copy.in to replace ’iidistdbname’ by ’iinewdistdbname’:

sql iinewdistdbname <copy.in

set def usr_disk:[mydir.distdbname]

Edit copy.in to replace ’distdbname’ by ’newdistdbname’:

sql newdistdbname <copy.in

Last modified date: 01/30/2023