Forum OpenACS Development: Import MySQL XML dump to PostGreSQL

Request notifications

Collapse
Posted by Iuri Sampaio on
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
Posted by Antonio Pisano on
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
Posted by Gustaf Neumann on
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