Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Converting SQL Server Stored Procedures to Oracle using Migration Workbench

Converting SQL Server Stored Procedures to Oracle using Migration Workbench

From: <david617_at_my-dejanews.com>
Date: Mon, 17 May 1999 20:48:17 GMT
Message-ID: <7hpvah$t6$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US