Re: Why SQL Server over MySQL
From: Kevin Kline (kevin.kline_at_quest.com)
Date: 09/27/04
- Next message: Dan Guzman: "Re: Incorrect syntax near the keyword 'Close'"
- Previous message: Fie Fie Niles: "Re: Incorrect syntax near the keyword 'Close'"
- In reply to: Mike London: "Why SQL Server over MySQL"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 26 Sep 2004 21:30:19 -0500
Hi Mike,
The most important difference is a lack of truly important features in
MySQL. For example, MySQL did not support any kind of atomic transactions
(i.e. the ability to explicitly rollback or commit a transaction) until
after version 4.0. Even then it's not a robust transaction processing
engine like SQL Server's. (MySQL's claims for high performance do not hold
true or are at least less true when many of their newest feautures are
enabled.) Another feature that wasn't supported until recently are
subqueries. Again, the support that is now present is much less than what
you'd get in a mature product like SQL Server. I believe that views are
also either not supported or only newly supported.
MySQL still does not support stored procedures. It is probably a biggy for
a lot of shops. Also, MySQL tools still leave a lot to desire. Expect to
spend a while getting up to speed on the tools, plus all the time needed to
figure out all of the stuff not supported by any sort of tool such as
editing the .INI files.
Finally, I have seen shops that have made good use of MySQL as part of their
corporate DB. In general, I've seen MySQL succeed in shops where the
database is essentially disposable, say where all the data is duplicated on
a couple servers. But they spent a lot of time getting a good understanding
of the features and capabilities of the product. Don't just jump into it
based on a few water-cooler discussions. It'll take real planning to make
your deployment work, should you decide to go on MySQL.
Best regards,
-Kevin Kline
SQL Server MVP
Quest Software (www.quest.com/quest_central/sql_server/freeware/)
The Professional Association for SQL Server (www.sqlpass.org)
"Mike London" <mikey@email.unc.edu> wrote in message
news:uxTC38XoEHA.2340@TK2MSFTNGP11.phx.gbl...
> We have several developers in our organization pushing to use MySQL but
> I have not heard any good arguments as of yet. I was wondering if any
> of you have any points that can be made for SQL Server versus MySQL.
>
> Personally I prefer SQL Server but I would be very interested in hearing
> your feedback on the matter.
>
> Thanks in advance,
>
> Mike
- Next message: Dan Guzman: "Re: Incorrect syntax near the keyword 'Close'"
- Previous message: Fie Fie Niles: "Re: Incorrect syntax near the keyword 'Close'"
- In reply to: Mike London: "Why SQL Server over MySQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
