Loading and Unloading Databases
Unload and Copy Operations
The unload database and copy database operations are most often used to copy or move a database or selected tables from one instance to another. They allow you to copy or move data from one instance to another instance with the same or different hardware or operating system.
You can also use these commands to:
• Copy a database or tables from one database to another on the same instance
• Document your database or specific tables using the “create” scripts produced by these operations
• Make static copies of your database or selected tables for the purpose of recovery
• Archive data that you want to purge from the database or reload later
The unload database and copy database operations generate scripts that enable you to:
• Unload an entire database to external binary or ASCII files
• Copy selected tables, or all the tables, views, and procedures that you own to external binary or ASCII files
• Reload the database or objects from these files
• Export table data into XML format using the genxml utility
• Import XML data files into Ingres, using the xmlimport utility
Both the unload database and copy database operations are two-phase operations, as follows:
1. Create a script to unload or copy the table or database.
2. Execute the script to copy data out of a database and into another database.