By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Porting from oracle to SQL Server

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.