Here’s a list with a feature comparison of the three most popular DB products (imho). Please let me know if you have any ¬†additional information, especially on the Oracle topic.

Product / FeatureMicrosoft SQLOracle RDBMSMySQL
Typical ApplicationsSharePoint, SCOM, SCCM, WSUSOBI, SAPJoomla, WordPress, MyBB, phpBB, Drupal, many open-source
Current VersionSQL Server 201211g5.5.x
HistoryFirst release in 1989, Based on Ingress (1974) / Sybase (1987)19791995
Operating SystemWindows Server, Windows ClientWindows, Unix, LinuxWindows, Unix, Linux, Mac and many more
LicensingClosed-source, proprietaryClosed-source, proprietaryOpen-source GNU-GPL
DriversODBC, JDBC, ADO.NET, OLEDB, Microsoft Visual Studio?ODBC, JDBC, ADO.NET, Microsoft Visual Studio
StandardizedANSI-SQLANSI-SQL
TransactionsYesYesUsing InnoDB storage engine
SchemaYesYesNo
Partial IndexYesYesNo
Computed columnsYesYesNo
FailureUsing MyISAM: UPS required, uninterrupted operation assumed
Active/Active clusteringRead-only on second nodeYes (RAC)No
Graphical Management ToolsYes: Management Studio and BI StudioEnterprise ManagerMySQL Workbench. Toad.
Maintenance Plan WizardYesNo
Job SchedulingYes (Agent)Yes (Oracle Scheduler)v5.1 (Event Scheduler)

References


1 Comment on Feature comparison Microsoft SQL Server, Oracle, MySQL

  1. karthikaqpt says:

    Vey useful points to know about these differences.Learn sql basics from https://www.youtube.com/watch?v=7Vtl2WggqOg

Leave a Reply