Home » SQL & PL/SQL » Client Tools » Migration from postgresql to oracle (oracle 11, solaris 10)
Migration from postgresql to oracle [message #458627] Mon, 31 May 2010 15:11 Go to next message
evoradba
Messages: 112
Registered: April 2005
Location: Canada
Senior Member
Hello

I cant find any tools that can generate the DDL for all objects in Postgressql to migrate to oracle, I did sql developer however does not support postgresql, does anyone know of any tool that can migrate postgresql to Oracle?
thanks
Maria
Re: Migration from postgresql to oracle [message #458628 is a reply to message #458627] Mon, 31 May 2010 15:31 Go to previous messageGo to next message
BlackSwan
Messages: 26606
Registered: January 2009
Location: SoCal
Senior Member
Perhaps you are looking for "pg_dump -s".

GOOGLE is your friend, but only when you actually USE it.
Re: Migration from postgresql to oracle [message #458725 is a reply to message #458628] Tue, 01 June 2010 08:28 Go to previous messageGo to next message
evoradba
Messages: 112
Registered: April 2005
Location: Canada
Senior Member
well i search the entire google downloaded tools and did not work, i think my best friend will be the "old fashion" command line to create all ddl and import data using sqlldr
Re: Migration from postgresql to oracle [message #459762 is a reply to message #458725] Tue, 08 June 2010 04:43 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

I never used it. But I think that SwisSQL is what you are looking for. If you are willing to pay for it.
Previous Topic: DBMS_OUTPUT
Next Topic: spool
Goto Forum:
  


Current Time: Mon Oct 21 05:37:52 CDT 2019