A few years back I had some experience using this tool to migrate a MySQL database to a PostgreSQL. As far as I remember it was quite pleasant.<p>I had the some trouble with MySQL accepting invalid dates (like 0000-00-00) while Postgres rejects such dates. However, there was an option to convert such dates to NULL which saved the day.<p>Also you have to manually rewrite your views. Since we had a lot and also very complicated views I ended up materializing each MySQL view, manually porting it to Postgres and then comparing the result. That worked quite well.
I liked this tool. Just be sure that if you want to do stuff like transformations on the data that you are migrating that if you don't already know a dialect of lisp that you're going to have to pick that up real fast.<p>Might be viable if you have time to do that but if not strongly consider writing your own migration scripts in python or whatever you already know.
I had a great experience with pg_loader in 2014 but I had to use SBCL to make it work reliably. I'm curious if someone can inform my experience there -- I'm not a regular CLisper, I just followed some advice I found on a forum.
I wanted to use it as well on windows the other day.
Because I wanted to migrate a mssql database to PostgreSQL. However AFAIR there were no builds I could find and from what I read in the issues it is quite discouraging, a pity