2. Using Ingres Commands : relocatedb Command—Move a Location to a New Location : relocatedb Example: Copy Database to a New Database
 
Share this page                  
relocatedb Example: Copy Database to a New Database
The following command copies the empdata database to a new database called empdev:
relocatedb empdata -new_database=empdev
This command example does the following:
Inserts a record in the iidatabase table for this database.
Inserts a record in the iiextend table for all locations to which the new database is extended.
Creates all the directories and copies all the files from the old database to the new database.
Builds a database configuration file for the new database.
After the new database is created, you should be able to connect to it and access all data.