Abstract
MS SQL by Microsoft and MySQL by Sun Microsystems are two most commonly used relational database management systems that run on Windows and Unix/Linux/Mac operating systems, respectively. There are similarities and differences when SQL (Structure Query Language) is used with these systems to access and manage a database. This project report is an attempt to show similarities and differences that exist in table constraints, data types, types of tables, table creation, indexing, views, set operations, aggregate functions, insert, stored procedures, stored functions, triggers, flow control statements, cursor, transaction, multi-user usage and concurrency problems, and isolation levels for each of the database systems. SQL code and run examples illustrate similarities and differences in syntax, types of tables, types of indexes, limitations on data types, types of control flow statements, types of aggregate functions, and types of join tables that exist between MS SQL and MySQL. Both languages look very similar in syntax and differences are in procedure creation and reference, transaction, table constraints, and data types.