To move from Mysql into Posgres?

[mstdmstdd]

  Hello,

If there is some tools to move data of related tables with data from Mysql into Posgres?

I know usefull option if to use dumping:

mysqldump --compatible=postgresql

But are there some pipelines for this?

If this pipeline is able to create tables in destination db by source db - that would be great!

Thanks!

[requinix]

mysqldump produces SQL. psql executes SQL.

 

But first dump it to a file and verify it contains everything you need. If it doesn't then create a(nother) SQL file containing whatever additional commands you need, then execute that after the dumped SQL.