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

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.

Thanks
--
John Fabiani

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
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

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

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.

--Luss
  http://www.enterprisedb.com

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@yolo.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/

Pavel is doing nice work on Orafce & the EnterpriseDB PG Community Fund is now sponsoring him to do more.