Sql to Oracle

Hi,

I am looking for information related to migrating a Sql 2000 database to Oracle 9.2.0.4.
Can someone please share the areas of concern on this, like how big a deal is it and what are the major areas of concern.

I assume this is a big question , any information in detal would be highly appreciated!

regards
crishna1Asked:
Who is Participating?
 
stevetheskiConnect With a Mentor Commented:
first step is to learn PL/SQL
then you can use the oracle migration workbench
http://www.oracle.com/technology/tech/migration/workbench/index.html

then go back and rewrite ALL of your TSQL in the proper PL/SQL format
remember oracle offers the use of libraries and depending User defined functions not avail in sql server 7

Depending on the number of stored procs you have this can get rather tedious.  Also Make sure the indexes are ordered properly in your where clause.  SQL Server people don't seem to pay much attention to that.

Steve
0
 
crishna1Author Commented:
Thank you very mucgh for your immediate responce!

I am a layman to this, can you please eloborate "then go back and rewrite ALL of your TSQL in the proper PL/SQL format" .

thanks once again!
0
 
stevetheskiCommented:
there are a considerable amount of differences between TSQL and PL/SQL

look at the following documnet that shows converting oracle to sql server
many good points

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
0
 
PSSUserConnect With a Mentor Commented:
Steve

>Also Make sure the indexes are ordered properly in your where clause.
>SQL Server people don't seem to pay much attention to that.

Does that mean the optimiser isn't as efficient in Oracle? Surely if it's a stored procedure the the optimiser should take care of this while generating the execution plan when the query is saved.

I don't use SQL as much as I use Ingres. I know that Ingres's optimiser is good enough that you don't have to worry about the order.
0
 
stevetheskiCommented:
A good DBA always makes sure that indexes are ordered properly.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.