Which of the following relational database management systems would a company adopt (for migration), if any, MS Access, MS SQL Server or MySQL?
- by Hassan Hagi
Dear programmers, as part of my final year university project, I am conducting research into relational database management systems such as Microsoft Office Access 2007, Microsoft SQL Server 2008 and MySQL 5.1. The description does not need to be detailed however; I am trying to find empirical evidence and professional opinion/fact to determine which of the three databases are best suited for the required size of company (stated or unstated).
OS: Microsoft windows (XP or newer)
Please consider the following, but full details are not necessary:
Memory management
Migration
Design constraints
Integrity (data and others)
Triggers
User constraints
Ease of use
Performance
Crash Recovery (not the operating system)
Total Cost of Ownership (TCO)
Also any info on Open source (to do with the three RDBMS)
Thank you for your time and help.
Hassan Hagi