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?