Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > Re: migrate ORA...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 6 Topic 6814 of 7199
Post > Topic >>

Re: migrate ORACLE TO SQL

by gazzag <gareth@[EMAIL PROTECTED] > Apr 9, 2008 at 04:14 AM

> 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 =A0=3D=3D> varchar
> date =A0 =A0 =A0 =A0=3D=3D> datetime
> number =A0 =A0=3D=3D> 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 =A0these 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
im****tant 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
 




 6 Posts in Topic:
migrate ORACLE TO SQL
"news.free.fr"   2008-04-02 18:48:57 
Re: migrate ORACLE TO SQL
"fitzjarrell@[EMAIL   2008-04-02 12:47:17 
Re: migrate ORACLE TO SQL
"news.verizon.net&qu  2008-04-03 02:55:32 
Re: migrate ORACLE TO SQL
Robert Klemme <shortcu  2008-04-03 06:03:07 
Re: migrate ORACLE TO SQL
Mark D Powell <Mark.Po  2008-04-03 09:16:13 
Re: migrate ORACLE TO SQL
gazzag <gareth@[EMAIL   2008-04-09 04:14:14 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 19:31:34 CDT 2008.