Re: [Fwd: MS SQL compatible functions]

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 talking to 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 your db.  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