-1

Can we convert PostgreSQL (database and dump) to Oracle without lose information and without using another application from the Internet?

Mary Smith
  • 361
  • 1
  • 2
  • 11
  • Depends on how you took the dump. Have at it with an editor! – Laurenz Albe Jun 30 '20 at 11:32
  • It will also depend on just what kind of objects are in your dump, and whether the SQL produced is 100% compatible with the version of Oracle you are moving to. The more custom things that are in your database, the more difficult the migration could be. – pmdba Jun 30 '20 at 11:41
  • How should I take the dump to migrate it to Oracle? Can you give me the example with any editor, please – Mary Smith Jun 30 '20 at 11:43
  • Maybe we can convert `pg_dump database > database.sql` and insert `database.sql` to Oracle? – Mary Smith Jun 30 '20 at 12:02

1 Answers1

1

Yes, you should export PostgreSQL database in plain SQL format with something like:

pg_dump --column-insert database > database.sql

and adapt the generated SQL file to Oracle.

pifor
  • 7,419
  • 2
  • 8
  • 16