OraFAQ Forum: Client Tools » Migration from postgresql to oracle

Home » Other » Client Tools » Migration from postgresql to oracle (oracle 11, solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration from postgresql to oracle [message #458627]

Mon, 31 May 2010 15:11

evoradba
Messages: 144
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

Report message to a moderator

Re: Migration from postgresql to oracle [message #458628 is a reply to message #458627]

Mon, 31 May 2010 15:31

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Migration from postgresql to oracle [message #458725 is a reply to message #458628]

Tue, 01 June 2010 08:28

evoradba
Messages: 144
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

Report message to a moderator

Re: Migration from postgresql to oracle [message #459762 is a reply to message #458725]

Tue, 08 June 2010 04:43

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.

Report message to a moderator

Previous Topic:	DBMS_OUTPUT
Next Topic:	spool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 12 21:39:55 CST 2026