MySQL to PostgreSQL converter

[jeltz]

I would recommend using pgloader (http://pgloader.io/) instead. It is simple to use in the default case, but can be configured with rules for how data types should be converted if necessary. It can also clean up weird timestamps like 0000-00-00 00:00:00.

[adamferguson]

Upvote for pgloader. Moving data from SQL Server into Postgres with PGLoader has been fairly seamless and the maintainer is very responsive on Github.

[scrollaway]

Seconded. Used pgloader to turn a massive mysql database into postgres. Turned out great.

[anacleto]

+1 pgloader.

[bjacobel]

No foreign key support is kind of a deal-breaker. Hard to believe anyone who is actually in the position of needing this would have a schema so simple that it contains no foreign keys.

[maligree]

> so simple

or complex

[warbiscuit]

Hard to believe mysql doesn't include that data in one of it's dump formats.

[stephen]

We were getting really close to converting our RDS instance from MySQL -> PG, but now with Amazon Aurora being the spiffy super-scalable/etc. RDS engine, we'll probably end up moving to that when/if needed.

Which is a mixed blessing; Aurora sounds great, but I was looking forward to getting back into PG after years of RDS being MySQL-only.

[codexon]

I find the more difficult issue to be rewriting bulk "insert ignore" and "on duplicate key" queries.

[tiglionabbit]

Yeah, seems like postgres is the only database that doesn't support those things. I mean, I use postgres, but I curse the lack of this feature regularly.

[rpedela]

It is looking like some form of upsert will make it into 9.5, but not confirmed yet.

[caioariede]

https://github.com/philipsoutham/py-mysql2pgsql

Works very well for me.

I think the only limitation is related to spatial data. I'm not aware of anything else.

[pornel]

A big problem I've encountered was MySQL-specific functions used in client code.

Fortunately there was a project that reimplemented many of these functions in Postgres:

https://github.com/pornel/mysqlcompat

[chx]

There was but the last commit is from 2011?

[mihailshumilov]

Thanks for Your comments It's really very important for me I think that next version of converter will be supported raw dump format

[putna]

https://github.com/lanyrd/mysql-postgresql-converter

does the job for me

[pgib]

When I saw this was a PHP project: https://dl.dropboxusercontent.com/u/31250/gifs/no-thanks.gif

[pmelendez]

So... If I give you some binaries.. would you even care?

[sarciszewski]

Really? What does the language it's written in have to do with anything at all here?