RE: Migration from MSSQL to Oracle

> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of VIVEK_SHARMA
> Sent: Tuesday, 7 December 2004 23:35
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Migration from MSSQL to Oracle
>=20
>=20
>=20
> How is the NTEXT Datatype column in MSSQL to be migrated to =
Oracle?=3D20
> Any advice, tools, utilities, freeware, docs, links on the same &
> migration in general of the database from MSSQL on windows to=20
> Oracle on
> Linux?

Oracle Migration Workbench is a good place to start.  otn.oracle.com =
will point you in the right direction.

On the point of NTEXT columns, I'm assuming you only went NTEXT due to =
the 4000 character limit for nvarchars under SQL Server.  Oracle has a =
4000 character limit on varchar2 and nvarchar2 as well (let's not worry =
about semantic instead of character storage here), so you'll probably =
want to look at CLOB or NCLOB.  (BTW, anyone know if those sizes are =
still the limits in 10g?)=20

Jonathon Lewis' book has several good chapters on the real-world aspects =
of dealing with LOBs - I read them last night :-). I'm sure there are =
many other fine texts our there as well.

My 2 cents.

Ciao
Fuzzy
:-)
--
http://www.freelists.org/webpage/oracle-l

Other related posts: