 |
|
| Home -> PostgreSQL to MySQL |
|
pg2mysql converter (PostgreSQL to MySQL Converter)The pg2mysql converter is an online tool to convert/migrate existing PostgreSQL databases into MySQL. Simply dumping from Postgres and importing to MySQL does not work because of differences in syntax and data types. To use this converter, just create a postgres SQL dump (pg_dump -U username -s dbname > dbname.sql), and copy and paste it into the text area below. Click the Convert to MySQL button and the page will re-load with your new MySQL code that you can copy out of the textarea into a text editor to save and import into your MySQL database.Download the SourceDue to popular demand, pg2mysql has now been released under the GPL. Feel free to download and use. For a list of changes between versions, see the READMEDec 19, 2006 pg2mysql-1.2.tar.bz2 Aug 30, 2006 pg2mysql-1.1.tar.bz2 May 25, 2006 pg2mysql-1.0.tar.bz2 Notes: - No its not perfect - Yes it discards ALL stored procedures - Yes it discards ALL queries except for CREATE TABLE and INSERT INTO - Yes you can email us suggestsions: - In emails, please include the Postgres code, and the expected MySQL code |
|
|