News for hackers. Stuff that matters.

A comment on Babelfish: SQL Server-to-Postgres Translation Layer. Parent comment

Re:Babelfish: SQL Server-to-Postgres Translation Layer by gavinray on Tuesday December 01, 2020 @07:20PM (#25271836)
pgloader does this (and much much more) in a single command:

https://github.com/dimitri/pgloader

  pgloader \
    mysql://user:password@mysql:3306/database \
    postgresql://postgres:root@localhost:5432/postgres
This is a gem of a tool. Surprised nobody has mentioned it. Supports SQLite and MS-SQL too.

https://pgloader.readthedocs.io/en/latest/ref/mysql.html#

[ Parent | on HN ]
Re:Babelfish: SQL Server-to-Postgres Translation Layer by acmecorps on Tuesday December 01, 2020 @07:35PM (#25271961)
Absolutely, absolute love pgloader! So painless and quite straightforward. Saved me lots of time migrating my production db. Highly, highly recommend if anyone wants to migrate from MySQL to PG!
[ Parent | on HN ]