RE: Migration from MSSQL to Oracle
- From: "Grant Allen" <Grant.Allen@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Dec 2004 15:05:25 +1100
> -----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
:-)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
