Migrating from one database to another with Pentaho ETL

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 !!!

Bye,

Nicola