Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migration from MSSQL to Oracle
> -----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
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-lReceived on Wed Dec 08 2004 - 22:04:15 CST
![]() |
![]() |