469,632 Members | 1,590 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

Porting from oracle to SQL Server

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

Jul 23 '05 #1
4 1823
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

Jul 23 '05 #2
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 =-----
Jul 23 '05 #3
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
Jul 23 '05 #4
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


Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Vijay Singh | last post: by
3 posts views Thread by David Gray | last post: by
2 posts views Thread by gustavo_randich | last post: by
2 posts views Thread by egoldthwait | last post: by
42 posts views Thread by Paul | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.