MySQL vs Microsoft SQL [英] MySQL vs Microsoft SQL

问题描述

我一直在大学的电脑课上学习Microsoft Access 2007，看到它是一个非常强大的数据库程序...我意识到它可能不是一个web服务器数据库，但我正在考虑切换到MSSQL。

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.

MySQL和MSSQL之间最大的区别是什么？ MS有什么优点或缺点，我可能没有？如何使我比另一个更好？

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?

推荐答案

我已经广泛使用MS SQL Server。主要区别是MS SQL Server仅与Windows平台配合工作。 MySQL适用于所有平台。 MySQL是开源的，现在被Oracle收购，所以没有人知道MySQL的命运。如果你使用.NET或Windows平台，我建议使用MS SQL，否则明显的选择是MySQL。 LAMP使用MySQL。像Facebook这样的大公司使用LAMP和MySQL。许多银行像Chase使用.NET，因此主要是MS SQL Server。如果你是一个Windows风扇，去MS SQL服务器。如果你是一个相信开源的人，请去MySQL。

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.

这篇关于MySQL vs Microsoft SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！