Porting Microsoft SQL Server to Linux

I just want to add the author of the article, i.e. Hal Berenson, is one of the key architect behind SQL Server 7.0 which is a rewrite from the legacy Sybase code. More information can be found at: http://www.microsoft.com/about/technicalrecognition/SQL-Serv...

This is a great cost-benefit analysis that shows that it wasn't a technical/software/programming question.

This was really fascinating. It just goes to show you that there is a whole lot more than just code with something like this. My gut tells me that a unix SQLServer would have been a the poor stepchild of the family if they had gone this route. That said, it would be very nice if MS made genuine, supported drivers for SQLServer on unix. I know about FreeTDS, but that just doesn't cut it for something mission critical.

The discussion of admin tools is somewhat interesting - SQL Server's have been abysmal until recently. Seriously, if they couldn't have ported it to unix, at least offering some decent admin tools would have been nice.

I had a recent job where a very old NT4 box with SQL Server 6.5 was still installed. Getting the data off it to a modern platform involved the following upgrade version chaining.

6.5 -> 2000 -> 2005 32-bit -> 2005 64-bit -> 2008 R2.

So, 5 conversions, as there wasn't a simple "dump to text" tool. The silly thing is that database was under 100MB in size. (we did try dumping it into Access but certain saved procedures and other stuff in the DB wouldn't come over)

Then, after all that trouble, we realized that the client program was 16-bit, so they have to do a rewrite to run on x64 platforms (or run VM's, great...). And nobody has the code as the guy who wrote it fell off the planet.

Have you tried 'bcp'?