Migrating from one database to another with Pentaho ETL

From PostgreSQL wiki
Jump to navigationJump to search

Note: this tool is no longer available, and the link does not lead to a version of this tool. This page is kept for the moment as a reference.

Migration (schema + data) from one database to another can easily be done with Pentaho ETL. It's an opensource software and I personally recommend you to take a look at.

Steps for migration are very simple:

1) Create a New Job

2) Create Source Database Connection

3) Create Destination Database Connection

4) From Wizard menu, choose Copy Tables Wizard...

5) Choose Source and Destination

6) Run the task

That's all folks !!!