mstdmstdd Posted January 28, 2018 Share Posted January 28, 2018 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! Quote Link to comment https://forums.phpfreaks.com/topic/306348-to-move-from-mysql-into-posgres/ Share on other sites More sharing options...
requinix Posted January 28, 2018 Share Posted January 28, 2018 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. Quote Link to comment https://forums.phpfreaks.com/topic/306348-to-move-from-mysql-into-posgres/#findComment-1555819 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.