Hacker News new | ask | show | jobs
by lukastr0 2393 days ago
Pgloader is a great project, and I planned to use it for database migration of a small commercial product (from SQL Server).

Unfortunately, I never go it to work. Tried three different distros (Ubuntu / Debian / Amazon Linux). Sometimes installation would fail, other times it would crash on first run - even when following instructions to the letter.

When I finally got it to run, it could not connect to SQL Server, and no one on Github could help with my particular error message.

Ended up writing the migration code myself, which took only a few hours. The lesson: for a very simple migration, pgloader was actually overkill and a self-made solution did the job quicker.