![]() Let’s begin… MySQL on Windows? Absolutely!Īlmost two years ago, I wrote an article entitled “ MySQL on Windows? Absolutely!”, where I talked about how prevalent MySQL is on Windows and why Microsoft is a great platform for our database. So why is this the case? Why should you, if you are using SQL Server today, consider moving your current applications to MySQL or use MySQL instead of SQL Server for new applications? In an article of this size, I can’t possibly cover every factor or consideration in detail, but I can try and hit the high points which hopefully will be enough. When it comes to migrating away from another database to MySQL – or using another database for new applications – the #1 database platform is Microsoft, three years running according to our year-end surveys. Moreover, a lot of other folks seem to agree. But I do think MySQL has SQL Server beat in many respects, even when it comes to running on the Windows platform. Of course, you can say I’m biased because I oversee product management for MySQL inside of Sun, so guilty as charged there. ![]() But don’t misunderstand me, in my DBA days, SQL Server was still the easiest to use over all its competitors and I never thought I’d find another database server that could equal it in terms of having the total package of ease-of-use, reliability, and good performance. The same can be said (in my opinion) of SQL Server 2008 in terms of additional management help. SQL Server 2005 came along with a little more help in the area of management, but it wasn’t as much as in prior versions. Oracle’s done a lot to improve their tools and overall manageability over time and today they are way ahead of where they were in the version 8/9i days with their 10/11g tools, but Microsoft has kept moving forward too. I was doing a lot of Oracle at the time too, but still felt that SQL Server had an edge on Oracle in terms of ease-of use. I started managing a lot more database servers with SQL Server 6.0, 6.5, and then SQL Server 2000. ![]() Take the tools away, and you basically had Sybase on Windows with the ISQL command line tool, which was not pretty by any means. Coming from the other databases, I found SQL Server the easiest and quickest to learn at the time, but of course, a lot of that had to do with the fact that Microsoft was really the only database vendor around then (I started with version 4.2 of SQL Server) that shipped any decent GUI management tools with their server. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL). Before we get started, let me say that I always liked being a SQL Server DBA. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |