Re: Translating Ora PL/SQL to Syb Transact-SQL (and vice versa)

From: KenNorth <knorth_at_my-deja.com>
Date: Wed, 1 Dec 1999 00:56:16 -0800
Message-ID: <ujCiJm9O$GA.188@cpmsnbbsa02>

Kai-Joachim Kamrath <kamrath_at_bsr.com> wrote
> Has anyone come across a utility that will (reasonably) convert Oracle
> PL/SQL program units to Sybase Transact-SQL (and vice versa)?
>
> I need to provide scripts on both platforms, and I'm having to manually
keep
> them in synch.

If this will be a repetitive process, you probably want to investigate Java in the database. That will give you the most portable solution for stored procedures:

http://www.devx.com/upload/free/features/javapro/1999/03mar99/kn0399/kn0399. asp Received on Wed Dec 01 1999 - 02:56:16 CST