MsSQL vs MySQL

hi,

Please my comment inline...

1. What is the maximum size of database that MySQL provide?
   The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.
   please refer.. http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html
2. Whether the stored procedure and join query are faster than the MsSql?
   NO.
3. Whether MySQL is user friendly as compare to MsSQL?
   yes.
4. Does it provide all the features that MsSQL provide?
   no MSSQL has feature like CDC,CT,Database Mirroring,Database snapshot etc are not available in MySQL.
5. Which one is more powerful?
   ofcourse MSSQL.

More information please refer..

http://www.mssqltips.com/sqlservertip/1920/microsoft-sql-server-vs-mysql/

hope this will help you.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi,

Please my comment inline...
1. What is the maximum size of database that MySQL provide?
   The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.
   please refer.. http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html
2. Whether the stored procedure and join query are faster than the MsSql?
   NO.
3. Whether MySQL is user friendly as compare to MsSQL?
   yes.
4. Does it provide all the features that MsSQL provide?
   no MSSQL has feature like CDC,CT,Database Mirroring,Database snapshot etc are not available in MySQL.
5. Which one is more powerful?
   ofcourse MSSQL.
More information please refer..
http://www.mssqltips.com/sqlservertip/1920/microsoft-sql-server-vs-mysql/
hope this will help you.