|
|
|
They are basically alike in that both are data storage and retrieval systems.
The differences are
1)open vs. proprietary. MS-SQL Server is closed.
2)Licensing costs: MySQL isn't always free, but it is cheap.3
3)Performance, MySQL is the leader, mostly due to its default table format, MyISAM.
4)Replication and scalability: A dead heat, but I guess it is easier to maintain replication with MS-SQL Server.
5)Security: Both products have perfectly acceptable default security mechanisms
6)Recovery: Advantage SQL Server: Failsafe and recovery is one area where MySQL, in its default MyISAM configuration, falls a little short.
Finally, the best choice depends on the situation.
|
|
