On Friday 30 June 2006 09:17, Jason McManus wrote:
> On Converting from MySQL 5.0.x to PostgreSQL 8.1.x
> * There is a conversion utility called 'mysql2pgsql' that will convert
> dump files from the mysqldump format, to a format that psql can
> understand. It is available at:
> - http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
FWIW, I have some decent success using mysqls mysqldump programm with various
--postgresql-compataible flags to get postgresql workable dumps. The flag
tree of that program is a killer, but if you can figure out the right flags,
the output is pretty good.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
In response to
pgsql-www by date
| Next: | From: Robert Treat | Date: 2006-07-03 15:35:39 |
| Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4 |
| Previous: | From: Dave Page | Date: 2006-07-02 15:00:25 |
| Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL |
pgsql-general by date
| Next: | From: Robert Treat | Date: 2006-07-03 15:35:39 |
| Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4 |
| Previous: | From: Csaba Nagy | Date: 2006-07-03 15:16:33 |
| Subject: Re: [JDBC] Is what I want possible and if so how? |