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 <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
