Question:
SQL Server or MySQL ?
viperone999
2009-10-24 02:40:10 UTC
I am relatively new to being a network admin and now they would like me to manage our databases as well. We have an old system and I'm looking to upgrade. I have reviewed both MySQL and SQL Server and I am still at a loss. any recommendations???

Please be specific. This is my job. Thank you!!!!!
Four answers:
Stuart
2009-10-24 05:53:56 UTC
It really depends on the size of the database, the software systems already in place in your operation, plus the reporting requirements and functionality of the database.



Do you already have either of the vendors systems in place in your business operation, then stick with that one.

If the database is large (+200GB, or is forecast to be before 3yrs) and has lots of users, then go for MySQL as it is more scaleable.

If the database is smaller and has less users then use SQL Server.

If you will have to setup data loading (as in a datawarehouse) then SQL Server has a set of tools known as sql server integration tools which are very useful. Also comes with reporting services (allows you to publish intranet based reports very quickly) and business analysis tools to do OLAP.

The other choice is your server OS, MSSS limits you to MS OSs, My SQL will allow you more choice in server OS.



To review, if your users would benefit from you being able to tweak and configure to the nth degree because of the large scale of the data, large user base and dynamic nature of the data ... MySQL



If this is not so then you would benefit from the simplicity of MSSS in that there is much less that you as a DBA can do wrong.



Its not what is under the hood, it is what you need it for.
Nigel
2009-10-24 04:19:40 UTC
One thing to consider is the support. If your system is such that an outage while you wait for support isn't an option, make sure you have a contract with someone to support you. If your new, then sometimes issues which may be simple to other people could take ages to find out ( even with communities on the web ).

There are places that support MySQL, so check the options and make sure your happy with any crap if things go wrong.
Ramon
2009-10-24 02:46:35 UTC
I have used both over the course of the years and I recommend MySQL.



Only stick to MS SQL if you have a strong MS footprint on your network with stuff you'd like to integrate such as Sharepoint.



Otherwise go with MySQL.
2009-10-24 02:44:07 UTC
i'm also new.

MYSQL is open source and therefore long term cost benefits make it worth it.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...