Migrating from one database to another with Pentaho ETL
This page contains historical information or deprecated articles.
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 !!!