Re: does anyone have a tool to convert SP'sT-SQL to Postgres

Denis Lussier wrote:
> Oracle provides a free tool for converting TSQL into PL/SQL.
>
> You can then use the PL/SQL on an EnterpriseDB database, if this doesn't
> work for ya... PL/SQL is quite a bit closer to PLpgSQL than TSQL is so
> you'll be well on your way.

There is also the open source Orafce project that can help you with a
lot of the oracle specific functions. You can find it on pgfoundry --
http://www.pgfoundry.org/

Joshua D. Drake

>
> --Luss
> http://www.enterprisedb.com
>
> On 2/9/07, johnf <jfabiani(at)yolo(dot)com> wrote:
>>
>> On Friday 09 February 2007 04:43, A. Kretschmer wrote:
>> > am Thu, dem 08.02.2007, um 21:28:08 -0800 mailte johnf folgendes:
>> > > Hi,
>> > > I'm hoping someone has already taken the time to write a routine (in
>> some
>> > > language - python,perl, etc..) to convert MS SQL T-SQL stored
>> procedures
>> > > into Postgres PL/pgSQL. And of course they are willing to share.
>> >
>> > See there: http://www.postgresql.org/docs/techdocs.3
>> >
>> > I hope, you can find what you need.
>> >
>> >
>> > Andreas
>>
>> Thanks the link is helpful. It's just I was hoping to find a script that
>> could care of most of the convert and just needed a little hand coding.
>> --
>> John Fabiani
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/