6. Loading and Unloading Databases : Copy Operation : Scripts Produced by the Copy Database Operation
 
Share this page                  
Scripts Produced by the Copy Database Operation
When you perform the copy database operation, the following two scripts are produced:
copy.out
The copy.out script contains query language statements to copy your tables to operating system files. The script contains a copy statement for each table being copied
copy.in
The copy.in script contains query language statements to recreate your tables, views, procedures, and associated indexes, permissions, and integrities, and copy the table’s data from the operating system files into a database.
To copy the tables out of the database, you run the copy.out script. To copy them into the same or another database, you run the copy.in script.
If you specify a particular table or view, the copy.in script contains statements to recreate the specified table or view only (along with applicable permissions and so on). The script does not contain statements to create all tables, views, and procedures.
Ingres tables can also be copied into XML format, as described in Generate XML and Import XML Operations.