Jump to content


Photo

To move from Mysql into Posgres?


  • Please log in to reply
1 reply to this topic

#1 mstdmstdd

mstdmstdd
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 28 January 2018 - 09:02 AM

  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!



#2 requinix

requinix
  • Administrators
  • Maddening Administrator
  • 9,663 posts
  • LocationWA

Posted 28 January 2018 - 09:20 AM

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.
The Reimann Zeta Function Trolley Problem | "Humans aren't delicious enough to be made fools of by mice."




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users