Transfer Entire Database to another Database

Posted on March 17, 2009 at 5:43pm

 

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?

 

Thanks.

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

3 Answers:

Posted on April 9, 2009 at 6:43am

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
robinzone
52
Joined: Dec 22 2008 - 10:55am
Last seen: 14 years 9 months ago
Posted on June 30, 2009 at 2:48am

Hi,

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: http://www.talend.com/

tguru's picture
tguru
138
Joined: Jun 12 2009 - 2:44am
Last seen: 14 years 3 months ago
Posted on August 13, 2009 at 12:00pm

 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
jeromepineau
37
Joined: Aug 4 2009 - 2:16pm
Last seen: 14 years 1 month ago
Feedback
randomness