Click to See Complete Forum and Search --> : Porting from MS SQL Server to Oracle


apar_6
05-17-2003, 02:08 AM
Hi,
Need help on porting code from MS SQL Server to Oracle. Could u please advice on the requisites for porting ? In our case, SQL Server has stored procedures also. Will there be any extra effort required to port stored procs ? I have not worked on SQL Server. Can the codes written in SQL Server be re-used as is or is any alteration needed ? I would like to know about how constraints are dealt with.

Regards,
Aparna S.

rotem_fo
05-18-2003, 06:35 AM
Hi,
You can use Oracle's Migration toolkits.
They work great.

http://otn.oracle.com/software/tech/migration/workbench/content.html

Cheers,