How to migrate from PostgreSql to MySql

[Pushkar]

I have installed TimeTrex_Standard_Edition_v2.2.17, with PostgreSql as the default Database. I would like to migrate PostgreSql8.2 to MySql 5.0.

Do I have to reinstall the entire application or can I migrate from one database to another database?

Could any body let me know, How can I migrate existing application from PostgreSql8.2 to MySql 5.0.

Thank you.

[shaunw]

There is no easy way to migrate between databases, they are simply too different.

I wouldn't recommend switching away from PostgreSQL anyways. MySQL is a downgrade in every way, including reliability. Search these forums and you'll see almost 10:1 ratio of problems with MySQL compared to PostgreSQL, and MySQL is just a small portion of the overall install base.