Porting from oracle to SQL Server

[golu]

Has any body done the porting from oracle to sql server, what were the
issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project
TIA
Golu

[John Bell]

Hi

This may give you a start!
http://www.microsoft.com/resources/d...rt2/c0761.mspx
http://vyaskn.tripod.com/oracle_sql_...quivalents.htm

John

"golu" <sa***********@lgsoftindia.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Has any body done the porting from oracle to sql server, what were the
issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project
TIA
Golu

[DA Morgan]

golu wrote:

Has any body done the porting from oracle to sql server, what were the
issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project
TIA
Golu

Oracle's multiversioning does not exist in SQL Server.
Oracle's sequences do not exist in SQL Server.
Oracle's unlimited row level locks does not exist in SQL Server.
Many of Oracle's trigger types do not exist.
Same holds for partitions, IOTs, GTTs, and numerous other object types.

In short ... I'd suggest you rewrite ... not port.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

[JinJJa]

It is best to use SQL DTS to port Oracle to SQL. It is, however, a very tricky
process and I recommend you do not proceed without an extensive research (sorry
but the steps are too many to mention here).

Oracle's sequences do not exist in SQL Server.
SQL has identity columns, which, of course, are different from Oracle's
sequences. But they are highly similar.

Oracle's unlimited row level locks does not exist in SQL Server.

I hear this a lot from Oracle folks. But SQL had row level locking since SQL 7.
And having an "unlimited row level locking" isn't even adviced or efficient in
most cases.

Joe
MCDBA, MCSD, OCP

[database.replication]

DTS would be convinient tool if tables are not very big.

If size of Oracle database and batch window are concerning, you may
want to check out FastReader : http://www.wisdomforce.com for
integrating SQL and Oracle on a continuing basis
golu wrote:

Has any body done the porting from oracle to sql server, what were the issues in porting the data bases?
Also suggest some resources which can be helpful in the porting project TIA
Golu