What is the best configuration for migrating data from MySQL to Postgres in my situation?

DonH's profile image DonH posted 2 years ago in General Permalink

I have a phpBB forum that uses MySQL. I want to migrate the forum to a different software that uses postgres. There are many ways to do this but I think that HeidiSQL might be useful.

I am starting out with a clean Windows 10 machine but have WSL enabled so I can work in Linux too. I have not yet installed MySQL or Postgres. These come in several versions each.

MySQL can be installed for Windows and IIS, with WAMPServer under Windows, as a standalone install on Ubuntu under WSL or as a container under Docker for either WIndows or linux.

Postgres is more limited but still there are installers for Windows, linux and containerized Docker.

Which ways work best with HeidiSQL?

Specifically, should I install MySQL under Windows with IIS or with WAMPserver?

Should I install Postgres for Windows or under WSL?

DonH's profile image DonH posted 2 years ago Permalink

Also, does it matter if I install HeidiSQL before or after the database installs?

Please login to leave a reply, or register at first.