4 ms·
I would recommend using pgloader (http://pgloader.io/ http://pgloader.io/) instead. It is simple to use in the default case, but can be configured with rules fo
by jeltz 12y ago
I would recommend using pgloader (http://pgloader.io/ 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.
- scrollaway 12y agoSeconded. Used pgloader to turn a massive mysql database into postgres. Turned out great.
- adamferguson 12y agoUpvote for pgloader. Moving data from SQL Server into Postgres with PGLoader has been fairly seamless and the maintainer is very responsive on Github.
- louthy 12y agoThere 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 :)
- jeltz 12y agoNice 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).
- anacleto 12y ago+1 pgloader.