Re: Migration from sql server to oracle

On Oct 10, 8:26 am, "kunal" <kunal.jet..._at_gmail.com> wrote:
> Hi,
>
> I need to migrate from sql server to oracle..
>
> access to sql server is restricted...only select and few more grants
> are given to us..
>
> we need to take that data into oracle.. flat file is one option but we
> dont need that one as solution as it needs manual intervention..
>
> we have used hs services of oracle.. which is working fine except ntext
> column in sql server..
> which is creating lots of problem...
>
> can anyone suggest how to create an exact replica of the table at
> source end with ntext column in oracle..replica means data only..
>
> we r able to fetch the data using dblink to sqlserver but unable to
> create mlog in oracle...
>
> please help it s urgent

There is no such thing as urgent in a free volunteer support forum. If it is really urgent get paid support. Also Oracle has a free product called Migration Workbench on http://otn.oracle.com which allows you to migrate from Sqlserver to Oracle.
As the datatype ntext doesn't exist in Oracle, your table can be probably converted by OMWB, but it will never be an exact replica. Sqlserver and Oracle are not compatible. I would start reading the Oracle documentation (at the same site) NOW.

-- 
Sybrand Bakker
Senior Oracle DBA