Is there any method to tranfer the data and schema from a postgresql database to mysql?
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. | |||
feedback
|
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. | ||||
feedback
|