| SQL SERVER 2005 | MySQL |
| 1.Commercial Database Paradigm | 1.Open Source |
| 2.Good for Large enterprise databases.Very fast and robust. | 2.Used in Small scale databases |
| 3.Performance Tuning as Easily and quickly | 3. Performance Tuning not easy as Sql Server 2005 |
| 5. fail safe and less prone to data corruption | 5.MySQL falls short in recovery with its default MyISAM mechanism. The UPS assumes uninterrupted data,and in the event of an unexpected shutdown your data can be lost and the data store corrupted. |
| 6. Backup strategy is more efficient by the Differential and filegroupbakup plans | 6.Backup methods are not good as compared to Sql
Server 2005. |
| 7. Price high | 7. Less Price. |
Conclusion:
choosing between a MySQL and SQL Server DBMS is a matter of the scale of the database application. For enterprise-level applications, SQL Server wins hands down. It has advanced set of SQL features, superior replication, clustering, security and management tools.
For lower-tier database applications, MySQL can offer the core functionality you require at a very low cost. Some might argue that the latest offering from MySQL has made the open source database system enterprise “worthy”, but this remains to be seen. The advanced functionalities implemented are yet to stabilise and be rationalised across the database engine. What’s more, Microsoft has upped the ante with even more advanced features of its own. It’s up to MySQL to rise up to the challenge, but at this point in time MySQL is nowhere near the competitive enterprise field of the more established SQL Server 2005.
Manoj
14 years agoHi varun,
Do u remember me..
Happy to know that u have started a website..I have told that u will grow like anything..
Ok let’s come to this comparison..I accept that SQLServer is having an upward trend in market and is giving Oracle run for its money..But never give a 1 sided comparison..tell MySQL’s advantages too..
1. MySQL is cross platform supported.
2. It has a pluggable storage engine.
3. Cost..lets not forget that..
MySQL’s market space is different..Compare SqlServer and Oracle..I will be visiting u frequently 🙂
admin
14 years agoManoj i ofcourse remember u. What u said is right.I never tried to give a one side comparison.u noticed some points, thats points are already there.
1. MySQL is cross platform supported. => I missed that point,i hope every one know that point.
2. It has a pluggable storage engine. => These pluggable storage engines are combined in the sql server.
3. Cost..lets not forget that.. => About cost it was there.(i mentioned mysql is less price(production DB). But remember that sql server is not a just a database.
Mysql Supports following Storage Engines,
MyISAM
Cluster
Federated
Archive
Merge
Memory
CSV
Blackhole
Falcon New!
Thanks for this response.Keep visiting.Comparison with sql server and Oracle will be coming soon.