mousingsurface Posted March 18, 2009 Share Posted March 18, 2009 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. Link to comment Share on other sites More sharing options...
robinzone Posted April 9, 2009 Share Posted April 9, 2009 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. Link to comment Share on other sites More sharing options...
tguru Posted June 30, 2009 Share Posted June 30, 2009 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/ Link to comment Share on other sites More sharing options...
jeromepineau Posted August 13, 2009 Share Posted August 13, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now