Re: Best way to convert SQL databases to Oracle?

Admin.Matthew_at_gmail.com wrote:
> Thanks for all of your replies. I would have responded sooner but
> Google Groups didn't show that anyone responded yet and I found out
> differently when I viewed this thread.
>
> We are using Microsoft SQL Server 2000 and Oracle 10g. So far the best
> luck we have had is with Oracle Workbench and converting Access files
> instead of MS SQL files. The problem we run into though is a lot of the
> data isn't brought over (sometimes whole tables have no data). I'm
> thinking this might be due to there being a lot of curreny and memo
> fields and Oracle doesn't have a currency or memo datatype.
>
> Sorry for being ignorant but what is migration assistant? Is that
> different and better then the Oracle Workbench for what we are trying
> to do? Thanks for everyones help so far.
>

The official tool is named the Oracle Migration Workbench (OMWB for short)
My guess is you are referring to the same tool.

Currency and memo fields can migrate, as long as you specify the correct datatypes to map it to. Two obvious choices would be number and clob, although varchar couls be valid for memo as well, as long as the memo fields do not contain more than 4000 byte worth of characters.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...