Re:MySQL to PostgreSQL converter
by jeltz on Saturday February 28, 2015 @10:13AM
(#9123848)
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.
[ Parent
| on HN ]
Re:MySQL to PostgreSQL converter
by adamferguson on Saturday February 28, 2015 @01:07PM
(#9124448)
Upvote for pgloader. Moving data from SQL Server into Postgres with PGLoader has been fairly seamless and the maintainer is very responsive on Github.
There doesn't seem to be any mention of SQL Server on the site? I am in the process of researching a move to Postgres from SQL Server, so if you have any other info on how you achieved this that'd be very much appreciated.
EDIT I see it now. Still, anything that you think useful would be great :)
Nice to hear that it works so well already. It is a very new feature which was sponsored by the company I work for only a couple of months ago. We are not even done migrating our database yet (we have to convert stored procedures and the queries in the application too).
Re:MySQL to PostgreSQL converter
by scrollaway on Saturday February 28, 2015 @01:03PM
(#9124436)
Seconded. Used pgloader to turn a massive mysql database into postgres. Turned out great.