This is something that would be wonderful to have, a mapping of PostgreSQL functions to MSSQL Server functions. In
fact,I have been fantasizing about a compatibility module that would allow SQL Server applications to think they were
talkingto MSSQL Server when they were really talking to PG. That is a huge job, but my how many more people would
convert!
In the meantime, you will have to dump schema, twiddle them to meet PosgtreSQL requirements, and run them to re-create
yourdb. Your app will have to be re-written to some degree as well.
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: iharding@tpchd.org
>>> Justin Clift <justin@postgresql.org> 02/06/02 02:31AM >>>
Hi everyone,
Dean here seems to be converting to PostgreSQL from MS SQL Server, and I
have *no* idea how to help him out.
He's not on the list, so if anyone's got suggestions, please remember to
keep him in the To/CC list.
:-)
Regards and best wishes,
Justin Clift
-------- Original Message --------
Subject: MS SQL compatible functions
Date: Wed, 6 Feb 2002 18:17:13 +0800
From: "Dean Lu" <>
To: <justin@postgresql.org>
Dear Justin,
My name is Dean Lu, I am working in a SI company in Taiwan, we are
going to change our products to support the PostgreSQL and drop the MS
SQL away, but I got some problems with the functions compatibility
between MS and pgSQL. Could you please give me some suggestions or tell
me where can I get the functions from Internet. It will be better if
those functions are written in C language. Thank you very much.
Best Regards'
Dean Lu
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
