[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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
0
crishna1
Asked:
crishna1
  • 3
2 Solutions
 
stevetheskiCommented:
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
 
PSSUserCommented:
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now