dbTalk Databases Forums  

migrate ORACLE TO SQL

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc migrate ORACLE TO SQL

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss migrate ORACLE TO SQL in the comp.databases.oracle.misc forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
gazzag
 
Posts: n/a

Default Re: migrate ORACLE TO SQL - 04-09-2008 , 06:14 AM





Quote:
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


Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top