convert MS SQL stored proc.s to Oracle 7.3?

convert MS SQL stored proc.s to Oracle 7.3?

Post by Terry R. Cole » Sat, 30 Aug 1997 04:00:00



Is anyone aware of a tool (program, Perl script, etc.) that can facilitate
the translation of a large number of MS SQL stored procedures written in
ANSI syntax into Oracle 7.3 SQL?

--
    Terry

------------------------------------------------------------

Virtual Chemistry, Inc.      http://www.VirtualChemistry.com
7770 Regents Road #251       619 587 8699 Voice/Fax
San Diego, CA  92122

 
 
 

convert MS SQL stored proc.s to Oracle 7.3?

Post by SF » Tue, 02 Sep 1997 04:00:00


Hi Terry!
I don't know of any such tools.  But if you need to maintain/edit Oracle
and SQL Server procedures side by side at the same time, check
SQL-Programmer 2.1 from Sylvain Faust.

Check http://www.sfi-software.com for details or call SFI at:
USA 617 722-9811
Canada 819 778-5045

It also features an automatic documentation generator and a lot more.

Sam,
SFI, a Sylvain Faust company
http://www.sfi-software.com
819 778-5045
===========================



> Is anyone aware of a tool (program, Perl script, etc.) that can
facilitate
> the translation of a large number of MS SQL stored procedures written in
> ANSI syntax into Oracle 7.3 SQL?

> --
>     Terry

> ------------------------------------------------------------

> Virtual Chemistry, Inc.      http://www.VirtualChemistry.com
> 7770 Regents Road #251       619 587 8699 Voice/Fax
> San Diego, CA  92122


 
 
 

1. Personal oracle 7.3 to Personal oracle 7.3 ( SQL*NET)

Hi all,

I have been getting into SQL*PLUS  & PL/SQL - Oracle 7.3 -- My problem is
that I dont quite understand how to connect 2 PC together both using
personal oracle. I want to share a database across both machines. I'm using
LSNRCTL.EXE, the server command line is:-

lsnrctl.exe start listener

and the client command running in SQL*PLUS 3.3 is:-


I have TCP/IP & SPX setup on both machines using the SQL*NET Cfg utility.

Please,please any
idea's??????????????????????????????????????????????????????????????????????
??

CraigTimmis

2. Error 2827

3. Problems with Stored Proc on aggregated Fields in 7.3

4. XP Pro - SQL 2K Security Log issue

5. Converting Oracle Stored Procedures to MS-SQL

6. dbVISTA Indexed Files

7. Converting stored procedures from MS/SQL-Server to Oracle

8. Advice MS SQL 6.5 VS Oracle 7.3

9. Migrate from MS SQL SERVER to ORACLE 7.3

10. Oracle NT 7.3 VS MS Sql Server : Text Issues

11. Oracle NT 7.3 VS MS SQL Server 7.0 :Text Issues

12. MS SQL 7.0 & Oracle 7.2/7.3