Table of Contents
You can use Power*Architect to quickly copy data from one database platform (such as Oracle) and create a verbatim copy on another database platform (such as PostgreSQL). Power*Architect automatically checks for foreign key constraints in the target database and orders the inserts and deletes accordingly.
You can also use Power*Architect to copy data if the source and target databases are on the same database platform. However, in this case, it's usually faster and more reliable to use the database vendor's own tools to do a "dump-and-restore".
If you want to do something more complex than a verbatim copy, use an ETL tool such as Kettle. ETL tools offer great flexibility in extracting, transforming, and loading data between databases. For more information, see the section called “Using Kettle Jobs” .
To copy data:
Select Tools » Copy Table Data. The Copy table data dialog box appears.
Select the Source and Destination databases. If necessary, click Database Connection Manager to set up a new database connection.
Select the Truncate Destination Table check box to delete all existing data in the destination tables before copying the data from the source tables.
Warning: Only use this option if you are sure you want to delete the existing data in the destination tables.
Click OK.