MS SQL Server-> <some Open Source DB> is likely to be every bit as challenging, so it's pretty silly to propose it in this case.
If you search the PostgreSQL archives you'll find a good number of successful migrations from MS SQL. The major work generally seems to be in re-writing stored procedures. Not a drop-in replacement solution, I agree but consider this: what if a company wants to migrate their desktops to Linux but can't get the required connectivity to MS-SQL? Should they meekly accept that they're locked into M$ for ever? Or should they investigate ways of replacing MS-SQL (maybe even with another proprietry, but multi-platform, DB)? Which would you advise?
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
