Re: Best way to convert SQL databases to Oracle?

From: <roytmaned_at_yahoo.com>
Date: 19 Apr 2006 14:59:53 -0700
Message-ID: <1145483993.670547.20400@v46g2000cwv.googlegroups.com>

migration assistant is probably your best bet. There is still manual intervention involved because not all types may match up properly.
Also assistant will not rewrite stored TSQL code for you into PL/SQL, so you will have to do it yourself (if you have stored procedures, packages and triggers......)

Another option is to reverse engineer your schema into ERWIN or ERSTUDIO and then generate schema for Oracle.

Hope it helps,

Eugene Roytman

Admin.Matthew_at_gmail.com wrote:
> We are having problems converting our SQL databases over to Oracle. We
> have tried the free application Oracle provides on their web site and
> also tried using DTS. What is the best way to easily get databases to
> convert over without much extra work? These databases are not very
> complex so I don't see why we are getting so many errors during the
> conversation process.
Received on Wed Apr 19 2006 - 16:59:53 CDT