Q:

MySQL vs Microsoft SQL

I've been learning Microsoft Access 2007 in a computer class at college and see that it's a very powerful database program... I realize that it might not be the same as a web server database, but I was thinking about switching to MSSQL.  
What are the biggest differences between MySQL and MSSQL?  Does MS have any pros or cons that My might not have?  How would one benefit me more than the other?  

A:

I have used extensively MS SQL Server. The main difference is MS SQL Server works only with Windows platform. MySQL works with all platforms. MySQL is open source and now bought by Oracle, so no one knows the fate of MySQL. If you working with .NET or Windows platform, I would suggest working with MS SQL, else the obvious choice is MySQL. LAMP uses MySQL. Big companies like Facebook uses LAMP and hence MySQL. Many banks like Chase use .NET and hence mostly MS SQL Server. If you are a Windows fan, go for MS SQL server. If you are a guy who believes in Open source, go for MySQL.

