Re: Converting SQL Server Stored Procedures to Oracle using Migration Workbench

Hi,

If performance is an issue, I wouldn't use Java stored procedures. I've heard (from reliable sources) that they are much slower than PL/SQL stored procs.

Hope this helps,

Steve
david617_at_my-dejanews.com wrote in message <7hpvah$t6$1_at_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 Tue May 18 1999 - 17:15:54 CEST