Re: plug-n-play MS SQL Server replacement

Lane,

> So, here's my thought.  How difficult would it be to build a server daemon
> that used PostgreSQL on the backend, and presented it to the network as a
> SQL Server compatible DB?

I think you're on the wrong list for this question.    I take it you're 
talking a compatibitily layer, like Rosetta?

I would think that writing a program to broker requests on port 1433 and 
re-interpret SQL Server specific syntax would be a managable project for a 
good C or Perl hacker.   What would be difficult-to-impossible is:
1) making it scale & perform well (in my experience, MS SQL Server accessed 
through Rosetta loses about 40% performance and is very limited in 
scalability).
2) Making it integrate well with MS networking and the MS ODBC/OLEDB/ADO/.NET 
clients.

Also, if you have T-SQL procedures, you would have to somehow implement T-SQL 
for Postgres; translating the procedures is really not an option.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html