This code takes a mysql database and creates sql create and insert statements or pgsql. Index and primary keys are supported and referential integrity is there, but I'm not sure just how reliable it is. There is weak referential ordering when referential integrity is used...it just does reference counting without respect to reference names.
The mapping info is near the bottom of the script. The script uses phplib for database calls.
Good luck,
Tom
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
While I'm not interested in this, I do have some code that may be useful to you.
http://db.etree.org/wddx/mysql-psql.phps
This code takes a mysql database and creates sql create and insert statements or pgsql. Index and primary keys are supported and referential integrity is there, but I'm not sure just how reliable it is. There is weak referential ordering when referential integrity is used...it just does reference counting without respect to reference names.
The mapping info is near the bottom of the script. The script uses phplib for database calls.
Good luck,
Tom