Re: migrate ORACLE TO SQL

From: gazzag <>
Date: Wed, 9 Apr 2008 04:14:14 -0700 (PDT)
Message-ID: <>

> If you only have a few tables to do then manually mapping the columns
> is usually easy in the absense of LOB, long, and nvarchar columns.
> varchar2  ==> varchar
> date        ==> datetime
> number    ==> integer, float, decimal, money, etc ... depending on
> number value precision, scale, and value range.
> CLOB and Long would likely text columns.
> But if you know Oracle and PL/SQL  these are far superior products to
> SQL Server 2K or 5K and T-SQL.
> HTH -- Mark D Powell --

In addition to what everyone else has suggested, and regardless of how important you consider the underlying data model to be, you will also have to recode all your packages and stored procedure.

Why you'd want to is beyond me.

HTH -g Received on Wed Apr 09 2008 - 06:14:14 CDT

Original text of this message