RE: Migration from MSSQL to Oracle

From: Grant Allen <Grant.Allen_at_towersoft.com.au>
Date: Thu, 9 Dec 2004 15:05:25 +1100
Message-ID: <DCFC52557FAC7640A8782B13032B81B0BC7656@bishopsfinger.towersoft.canberra>

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of VIVEK_SHARMA
> Sent: Tuesday, 7 December 2004 23:35
> To: oracle-l_at_freelists.org
> 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

Received on Wed Dec 08 2004 - 22:04:15 CST