Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to import Oracle Procedures to SQLSERVER

Author  Topic 

deven
Starting Member

3 Posts

Posted - 2002-01-03 : 22:40:48
Is there any easy way to import Oracle procedure into Sql Server Stored procedure.

Thanks
Deven.T

Deven

Nazim
A custom title

1408 Posts

Posted - 2002-01-04 : 01:10:30
You Have to Rewrite them, coz there are lot of differences in Sql Server and Oracle Syntax and Functionalities. the way they declare variables etc.

Lot of them will not work in Sql Server.

Eg : there is OldValue, NewValue in Oracle , which you will not find in Sql Server you have to use Inserted, Deleted.

HTH


----------------------------
Anything that Doesn't Kills you Makes you Stronger
Go to Top of Page
   

- Advertisement -