From sgnerd@yahoo.com.sg Fri Aug 29 05:24:31 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id EA2C3D1B948 for ; Fri, 29 Aug 2003 05:24:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 89087-02 for ; Fri, 29 Aug 2003 02:24:01 -0300 (ADT) Received: from smtp018.mail.yahoo.com (smtp018.mail.yahoo.com [216.136.174.115]) by svr1.postgresql.org (Postfix) with SMTP id 7E0ACD1B8B1 for ; Fri, 29 Aug 2003 02:23:59 -0300 (ADT) Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 29 Aug 2003 05:23:58 -0000 Message-ID: <004a01c36ded$c8aaa850$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Migrating Stored Procedures from MS SQL Server Date: Fri, 29 Aug 2003 10:54:03 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0042_01C36E1B.DC7DA520" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=HTML_50_60, HTML_FONT_COLOR_BLUE X-Spam-Level: X-Archive-Number: 200308/351 X-Sequence-Number: 14967 This is a multi-part message in MIME format. ------=_NextPart_000_0042_01C36E1B.DC7DA520 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, I am about to do a migration of stored procedures from MS SQL Server to Pos= tgres. What is there any free tools available for it? Shall I write a SQL function or PL/pgSQL function for Stored Procedures? Pl= ease advise me on this. Thanks in advance. Kumar ------=_NextPart_000_0042_01C36E1B.DC7DA520 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear Friends,

I am about to do a migrati= on of=20 stored procedures from MS SQL Server to Postgres. What is there any free to= ols=20 available for it?

Shall I write a SQL functi= on or=20 PL/pgSQL function for Stored Procedures? Please advise me on this. Thanks i= n=20 advance.

Kumar

<= /HTML> ------=_NextPart_000_0042_01C36E1B.DC7DA520-- From davidw@unidial.com.au Fri Aug 29 05:32:20 2003 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 23201D1B8BC for ; Fri, 29 Aug 2003 05:32:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 89831-01 for ; Fri, 29 Aug 2003 02:31:48 -0300 (ADT) Received: from ozimelb03.ozicom.com (unknown [203.185.247.100]) by svr1.postgresql.org (Postfix) with ESMTP id 163DED1B8AB for ; Fri, 29 Aug 2003 02:31:45 -0300 (ADT) Subject: Re: Migrating Stored Procedures from MS SQL Server Date: Fri, 29 Aug 2003 15:31:44 +1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C36DEE.D51F17A8" Message-ID: X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 X-MS-Has-Attach: content-class: urn:content-classes:message X-MS-TNEF-Correlator: Thread-Topic: [SQL] Migrating Stored Procedures from MS SQL Server Thread-Index: AcNt7d1gOooGYjfwRTKkN7Qz5+OStQAAFmBA From: "David Witham" To: "Kumar" , "psql" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/352 X-Sequence-Number: 14968 This is a multi-part message in MIME format. ------_=_NextPart_001_01C36DEE.D51F17A8 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Kumar, =20 You'll need to use PL/pgSQL for your stored procedures. =20 When I migrated from Informix I found it was pretty easy - just a syntactic= conversion of the procedures and a few data types to rename. The tricky bi= t is when you have used a MS SQL Server concept that PostgreSQL doesn't sup= port. You'll need to write some new code or at worst redesign your logic to= work around the differences. I don't expect there would be automated tools= that could do that for you. =20 Regards, David -----Original Message----- From: Kumar [mailto:sgnerd@yahoo.com.sg] Sent: Friday, 29 August 2003 15:24 To: psql Subject: [SQL] Migrating Stored Procedures from MS SQL Server Dear Friends, =20 I am about to do a migration of stored procedures from MS SQL Server to Pos= tgres. What is there any free tools available for it? =20 Shall I write a SQL function or PL/pgSQL function for Stored Procedures? Pl= ease advise me on this. Thanks in advance. =20 Kumar ------_=_NextPart_001_01C36DEE.D51F17A8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi=20 Kumar,

You'll=20 need to use PL/pgSQL for your stored procedures.

When I=20 migrated from Informix I found it was pretty easy - just a syntactic conver= sion=20 of the procedures and a few data types to rename. The tricky bit is when yo= u=20 have used a MS SQL Server concept that PostgreSQL doesn't support. You'll n= eed=20 to write some new code or at worst redesign your logic to work around the= =20 differences. I don't expect there would be automated tools that could do th= at=20 for you.

Regards,

David

-----Original Message-----
From: Kumar=20 [mailto:sgnerd@yahoo.com.sg]
Sent: Friday, 29 August 2003=20 15:24
To: psql
Subject: [SQL] Migrating Stored Proced= ures=20 from MS SQL Server

Dear Friends,

I am about to do a migra= tion of=20 stored procedures from MS SQL Server to Postgres. What is there any free = tools=20 available for it?

Shall I write a SQL func= tion or=20 PL/pgSQL function for Stored Procedures? Please advise me on this. Thanks= in=20 advance.

Kumar

------_=_NextPart_001_01C36DEE.D51F17A8--