Migrating from MS SQL Server 7.0 to Oracle

Hi, all

We have a web-based application using ASP and the backend db is in MS Sql Server 7.0. We want to develop a version with an Oracle backend. We have Oracle 8i. We downloaded the Migration Workbench and did a preliminary migration which came back with about 50% of our 150 stored procedures failing to port. Most of the sps are basic select, updates, etc. But maybe 20 of them have temp tables and/or cursors.

Can anyone give us an idea of what it might take to port this over? We estimated that it would entail rewriting some sps and minimal changes to the ASP. In general, what sp changes might force the rewriting of ASP code? We were thinking that the changes would be invisible to the ASP...

Help!!! We also estimated a two months of time to do this and now we're thinking that it will take longer. Migration of the data model, the data itself, working on the ASP and then writing an application to migrate for upgrades... Does anyone have experience doing these?

Thanks!

M

--
Posted via CNET Help.com
http://www.help.com/