mysql data migration => postgresql?

V

vadv2013-02-21 21:47:11

MySQL

vadv, 2013-02-21 21:47:11

Tell me how easy and painless you can transfer data from mysql to postgresql. I came across such a thing github.com/ahammond/mysql2pgsql/blob/master/mysql2... in principle, it suits only there are problems with BOOLEAN fields from mysql - they are stupidly 0/1 in the dump, and postrgesql does not want to fill integer into boolean.

Reply

Answer the question

In order to leave comments, you need to log in

6 answer(s)

A

Alexey Lesovsky, 2013-02-23
@lesovsky

here is a good tool

A

asm0dey, 2013-02-21
@asm0dey

Personally, I found taps to be the most pleasant way .

P

Puma Thailand, 2013-02-21
@opium

Just make autocorrect true and false

M

Michael, 2013-02-25
@mtyurin

wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL

M

mihailshumilov, 2015-05-20
@mihailshumilov

https://github.com/mihailShumilov/mysql2postgresql

I

icemar, 2016-04-25
@icemar

https://github.com/AnatolyUss/FromMySqlToPostgreSql