Converting SQL Server Stored Procedures to Oracle using Migration Workbench

My company has created a client-server application which makes extensive use of Transact-SQL stored procedures in Microsoft SQL Server 7.0. We are looking to port the server application to Oracle using the Oracle Migration Workbench. This would be implemented through Java stored procedures.

Does anyone have experience in migrating from SQL Server to Oracle with this tool, especially in regards to stored procedures? What difficulties have you experienced? Are there any types of client-side code that had to be modified to accomodate these changes? How about performance issues on Oracle versus SQL Server on the same NT box?

Thanks in advance for your answers,

David Lawrence
Database Architect
Incentive Systems, Inc.
Burlington, MA
dlawrence_at_incentivesystems.com

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 17 1999 - 15:48:17 CDT