The guts of SQL Server were (and as far as I know still are) a RDBMS named Sybase that MS bought sometime in the mid '90s. Sybase ran perfectly fine on Unix, just without all the GUI crap.
Re:Why SQL server was never ported to Unix
by BarkMore on Sunday January 15, 2012 @12:53PM
(#3467707)
See http://hal2020.com/2011/07/27/porting-microsoft-sql-server-t... for a history of the SQL Server guts. It is now a complete rewrite of the Sybase code.
Oh, that's fascinating. Thanks!
Originally that was true, but the author mentions NT4 and I believe MS rewrote the engine specifically for NT...
Re:Why SQL server was never ported to Unix
by feralchimp on Sunday January 15, 2012 @10:59AM
(#3467393)
That had the ring of truth to me, and I've done a significant amount of porting to IBM z/OS and IBM System i (each of which have a lot higher 'weirdness' quotient than NT --> Unix.
If there is a compiler on the platform for the language in which the product is authored, getting core functionality standing up and walking can often be accomplished in a shockingly short timeframe. Getting things to run well, properly documented, interfacing as desired with other components on the system, and effectively marketed to a different audience...much harder and time/resource intensive.
Re:Why SQL server was never ported to Unix
by BarkMore on Sunday January 15, 2012 @10:57AM
(#3467386)
A single engineer got SQL Server up and running on Linux with a few weeks of effort. Berenson killed the project after this work was done.
It would have taken significantly more effort to bring the server to product quality on multiple *nix platforms.
Re:Why SQL server was never ported to Unix
by andreadallera on Sunday January 15, 2012 @08:59AM
(#3467138)
Exactly what i thought. Plus, from a marketing point of view, porting sqlserver to unix would have been suicide for Microsoft given their primary objective (for what concernes the server market) since XP is to enlarge their market to the server world. sqlserver is the main reason to have a windows machine at all if your team develops with .NET.
Re:Why SQL server was never ported to Unix
by eropple on Sunday January 15, 2012 @01:00PM
(#3467730)
I disagree. The main reasons I develop in .NET (as opposed to Mono) are tooling and performance. SQL Server is helpful in the cases where I need a RDBMS, but connecting to one's database of choice is generally painless.
I have a hard time believing that. I used to write to the Windows internals API a lot (the kind of stuff you see on sysinternals), and I can't imagine the sql server team not doing the same. That stuff was not easily ported to Linux, at least in the late 90's / early 00's.