Re: another migrating Q: stored procedure

"Lee, Seung K." wrote:

> I have about 70 stored procedures in mssql2000 format
> and having hell of a time converting by hand.
> Running out of time and brain power... :(
>
> It would be great if somebody can point me to a tool
> which does the job or to a reference I can compare the
> two type(ms and oracle) of stored procedures.

Since you were asking for a tool. Here it is (well, I cannot tell for sure what to do with mssql2000):

"Oracle Migration Workbench (Migration Workbench) is a tool that simplifies the process of migrating data and applications from non-Oracle databases to Oracle8, Oracle8i, and the Oracle Appliance 1.3.0. The Migration Workbench allows you to quickly and easily migrate an entire application system (that is, the database schema including triggers and stored procedures) in an integrated, visual environment." "Presently migrates from Microsoft SQL Server 6.5, Microsoft SQL Server 7.0, Sybase Adaptive Server 11, Microsoft Access 2.0, 95, and 97, MySQL 3.22 and MySQL 3.23."

Have a look at Oracle Technology Network (otn.oracle.com) for more information. Received on Sat Mar 10 2001 - 18:06:21 CST