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?
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/
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.