Overall Satisfaction with MySQL
We use MySQL as the back end database for our field studies as part of a WAMP server. Most of the company uses other products, but the full package nature and free development tools make MySQL a natural for this work.
- The SQL commands for MySQL tend to be simple and easy to complete.
- I like being able to get the columns from the table with 'SHOW COLUMNS FROM tablename'.
- MySQL allows us to publish as many websites as needed without licencing issues.
- And of course the price is right!
- SQL Server seems to have many more reporting options, SSMS allows for imports and exports to other office products out of the box.
- Since the rest of the organization uses other database products, I am on my own for support and upgrading.
- Since MySQL is essentially free, the return on investment is 100%.
- Time is the only requirement to get a MySQL instance working. As I gain more experience, set up gets easier and quicker.
- Microsoft SQL Server, SQL Server Integration Services, SQL Server Business Intelligence Manager and Couchbase Server
MySQL is open source, readily available, with no licencing issues. Adding a new web product to my existing setup is relatively straight forward. In order to set up a SQL Server site, significant IT and licencing costs are involved. We are implementing some SQL Server back ends for a couple projects simply because that is what IT supports and because we can use Power BI as part of our Office 365 package. I am more familiar with MySQL commands, sometimes SQL Server seems to obstruct my processes. Both SQL products can generate the 'do not understand' errors from malformed SQL queries. If I want to copy and paste SSMS seems to have a slight upper hand on ease of use. SQL Server has many features in the menus and under the hood, a dizzying array of choices and setup options and requirements. MySQL just works and gets out of the way.