Palani Kannan Palani Kannan - 2 years ago 282
SQL Question

Import MySQL dump to PostgreSQL database

I tried several ways through internet and scripts to use MySQL dump "xxx.sql" and ORACLE dump "xxx.dump" to postgresql database. Nothing worked for me. Kindly anyone suggest me to do this.

I want to import xxx.dump from ORACLE and xxx.sql from MySQL to postgresql database.

Answer Source

Don't expect that to work without editing. Maybe a lot of editing.

mysqldump has a compatibility argument, --compatible=name, where "name" can be "oracle" or "postgresql", but that doesn't guarantee compatibility. I think server settings like ANSI_QUOTES have some effect, too.

You'll get more useful help here if you include the complete command you used to create the dump, along with any error messages you got instead of saying just "Nothing worked for me."

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download