How to migrate data from MySQL database to PostgreSQL database?

[Aleksander Efremov]

Through script `GET` - `INSERT`? There is a tables with 2 million rows and more.

[Alexis Guajardo]

Hello Aleksander,

This is not something that is supported, however there is information publicly available that would offer some tips to be able to do this.

// Instructions for importing data into CloudSQL postgres

https://cloud.google.com/sql/docs/postgres/import-export/importing

// wikibook for converting a mysqldump output file to a postgres compatible dump file

https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL

// mysql docs regarding the --compatible flag

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_compatible

Alexis

CloudSQL Team

[Aleksander Efremov]

Thank you for information. I did it already through: https://github.com/dimitri/pgloader. Very fast.

пятница, 14 апреля 2017 г., 1:00:41 UTC+4 пользователь Alexis Guajardo написал: