Is there any method to tranfer the data and schema from a postgresql database to mysql?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Pg_dump will create a plaintext SQL script with the statements needed to re-create the schema and the data. You can then import this script into mysql. You may need to tweak the script in certain places due to postgres/mysql differences.
You can try a tool like Navicat Premium. It can do a structure/data compare or copy between db's. Never tried with postgres, but did from mysql to mssql and v.v.