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

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.