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

Hi

This may give you a start!
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm

John

[quoted text, click to view]

[quoted text, click to view]

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
damorgan@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!

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).


[quoted text, click to view]

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


[quoted text, click to view]

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

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


[quoted text, click to view]