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--