pgloader-for-windows

Build on Windows 11 with pgloader 3.6.9 release version for Migrate from MySQL to PostgreSQL

You can follow my instructions below to build other pgloader versions.

This is the pgloader's Introduction.

First

git clone https://github.com/dimitri/pgloader.git

Before you build pgloader,you need to prepare the following environment on your windows

• sqlite-dll-win-x86-3470200.zip,after you download it,copy sqlite3.dll to your pgloader directory
• If your windows does not have OpenSSL 3.x(Required),Please select Win32 OpenSSL v3.4.0(must) to download and install,after install，add it to your system's environment variables
• you also need sybdb.dll,download the FreeTDS binary file or bulid the FreeTDS by yourself.And then you will get sybdb.dll,add the path where sybdb.dll is located to the system environment variables，if you download the FreeTDS binary, the path to sybdb.dll is ...\vs2017_32-master\bin
• And then you need make to build,download the installer: msys2-x86_64-20241208.exe after install，add it to your system's environment variables.
• pgloader is written in Common Lisp, so you need to install SBCL (Common Lisp Compiler) to compile it.After install，add it to your system's environment variables.

If you have installed the above tools but the terminal cannot recognize them, reopen the terminal or restart

Next we will build

cd pgloader
make

then you will see pgloader.exe in \pgloader-3.6.9\build\bin.

Enjoy !