What are the reasons to use SQL Server instead of MySQL with a complex .Net project?
Posted
by cdeszaq
on Stack Overflow
See other posts from Stack Overflow
or by cdeszaq
Published on 2010-04-15T15:55:52Z
Indexed on
2010/04/15
16:03 UTC
Read the original article
Hit count: 289
We currently have a 10 year old nasty, spaghetti-code-style SQL Server database that we are soon looking to pretty much re-write from scratch as part of a re-write to a large web application. (The existing application will serve as the functional requirements for the next incarnation of the app) The new version will be developed in .Net, so a large portion of the application stack will be based on Microsoft technologies (Visual Studio will be used IIS will be the application server).
One of the developers on the project has raised the possibility of switching to MySQL instead of SQL Server in order to save on cost for both the licence of the DB server, as well as the tools to design and manipulate the DB (such as the wonderfully free MySQL Workbench).
What are the various pros and cons of using SQL Server vs. MySQL as the database for a complex .Net project? Price is one factor we have identified, both in terms of the DB server licence as well as tools to manipulate the DB, but what other factors come into play?
© Stack Overflow or respective owner