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

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

On 2/10/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> 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/
>
>