Transfer Entire Database to another Database


What is the quickest way to set up JasperETL for transferring an entire database (Postgres) to another database (MySQL)?


Do you need to go table by table and define it?



mousingsurface's picture
Joined: Mar 17 2009 - 5:38pm
Last seen: 14 years 6 months ago

3 Answers:

In mysql there is "show tables;" to get list of tables, something similar must be in postgres. the next step is "show fields from <TABLE_NAME>" to create tables using these fields and field types from result.

robinzone's picture
Joined: Dec 22 2008 - 10:55am
Last seen: 14 years 9 months ago


Jasper ETL is a tool that can load the entire database. Jasper ETL - Talend Open Studio - can perform this operation.


Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes. For more information:

tguru's picture
Joined: Jun 12 2009 - 2:44am
Last seen: 14 years 3 months ago

 I would ask to begin with whether you're looking to move over the metadata (schema) or the actual data as well? Because moving the schema is fairly simple (DDL) you can then export your data (say CSV) and push it back into the destination.  Maybe I misundertood your question.

jeromepineau's picture
Joined: Aug 4 2009 - 2:16pm
Last seen: 14 years 1 month ago