Forum OpenACS Development: Import MySQL XML dump to PostGreSQL

Collapse
1: Import MySQL XML dump to PostGreSQL
Posted by Iuri Sampaio on 02/05/14 11:36 PM
What would it take to a XML dump, created on phpmyadmin, from a MySQL be imported to a PostgreSQL database?

Later on, I will try to build OACS stuff under it.

Best wishes

Collapse
2: Re: Import MySQL XML dump to PostGreSQL (response to 1)
Posted by Antonio Pisano on 02/06/14 01:58 PM
Time estimates depend heavily on the amount of data, source data model AND target data model complexity and so on...

You can roll your own data extraction, transformation and loading by hand, or use one of the many tools available.

One which is quite popular and open source is Pentaho Data Integration, which Community Edition is available here http://community.pentaho.com/

Best regards

Collapse
3: Re: Import MySQL XML dump to PostGreSQL (response to 1)
Posted by Gustaf Neumann on 02/06/14 02:25 PM
If you can dump the tables to csv, these can very easily to imported into PostgresSQL with copy [1]. Two more approaches are suggested in [2].

[1] http://www.postgresql.org/docs/9.3/static/sql-copy.html
[2] http://stackoverflow.com/questions/19007884/import-xml-files-to-postgresql