Monday, March 12, 2012

MYSQL vs SQLServer

Hi
Please, i want to know advantages and disadv. of sqlserver and mysql.
OR
When to use each of them?
OR
Which is better?
OR
Any thing to compare?
Any information?
ThanxOriginally posted by Taymoor
Hi
Please, i want to know advantages and disadv. of sqlserver and mysql.
OR
When to use each of them?
OR
Which is better?
OR
Any thing to compare?
Any information?

Thanx

Advantages
----
MySQL is cheaper!
MySQL runs on Linux, Unix, Windows OS!

Dis-Advantages
------
MySQL does not support database Views.
MySQL does not support Stored Procedures.
MySQL does not support Triggers.
MySQL does not support sub-queries.
You must configure MySQL with the InnoDB storage engine if you want transaction-safe(rollback, commit, unit-of-work) tables, and referential integrity (foreign keys).
SQL Server comes with much nicer client tools.

SHAMELESS PLUG -
But, you can always get nice heterogeneous database UI tools at:
http://www.yazoosoft.com

No comments:

Post a Comment