How to Migrate from MySQL to PostgreSQL RDBMS: An Enterprise Approach

This page summarizes the projects mentioned and recommended in the original post on dev.to

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • pgloader

    Migrate to PostgreSQL in a single command!

  • pgloader compilation -------------------- Build pgloader from sources (1) Check OS: dima@dima-VirtualBox:~$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 20.04.3 LTS Release: 20.04 Codename: focal dima@dima-VirtualBox:~$ (2) Install git: sudo apt update sudo apt install git (3) Clone pgloader: mkdir my_pgloader cd my_pgloader/ git clone https://github.com/dimitri/pgloader.git (4) install packages necessary for build: sudo apt-get install sbcl unzip libsqlite3-dev make curl gawk freetds-dev libzip-dev (5) make build: make DYNSIZE=10240 pgloader (6) make outputs a ./build/bin/pgloader file for us to use. dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$ pwd /home/dima/my_pgloader/pgloader/build/bin dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$ ls -rtogla total 69160 -rw-rw-r-- 1 70 Jan 7 17:17 .gitignore drwxrwxr-x 5 4096 Jan 7 17:29 .. -rwxr-xr-x 1 41918800 Jan 7 17:29 buildapp.sbcl -rwxr-xr-x 1 29036008 Jan 7 17:29 pgloader drwxrwxr-x 2 4096 Jan 7 17:29 . dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$ cp pgloader pgloader_dima_dynsize_10240 dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$ ls -rtogla total 97396 -rw-rw-r-- 1 70 Jan 7 17:17 .gitignore drwxrwxr-x 5 4096 Jan 7 17:29 .. -rwxr-xr-x 1 41918800 Jan 7 17:29 buildapp.sbcl -rwxr-xr-x 1 29036008 Jan 7 17:29 pgloader -rwxr-xr-x 1 29036008 Jan 7 17:33 pgloader_dima_dynsize_10240 drwxrwxr-x 2 4096 Jan 7 17:33 . dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$ dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$ ./pgloader_dima_dynsize_10240 --version pgloader version "3.6.a94a0a3" compiled with SBCL 2.0.1.debian dima@dima-VirtualBox:~/my_pgloader/pgloader/build/bin$

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts