[google-cloud-sql-discuss] Re: How to migrate data from MySQL database to PostgreSQL database?

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 написал:

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

On Thursday, April 13, 2017 at 6:12:24 AM UTC-7, Aleksander Efremov wrote:

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/728e25ad-96c8-4d19-976e-7c58537f1801%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.