You can use Pentaho Data Integration (Kettle) to Transfer Data from One Database to another. Its very easy as the transformation is automatically created just by creating the connection.and it can transfer Lacs of records very quickly.
Transfer Data from one Database to another using Kettle (PDI) Related Examples