MySQL vs MS SQL

How do these two data bases compare to each other?

Is mySQL as secure as MS SQL?

Is programing for one compatible for the other?

etc.

That is a big question:

1. MySQL, as with MSSQL is about as secure as your server is, which means it's really a combination of things. I would think MySQL running on a properly setup Unix server would be as secure as or more secure than MSSQL

2. It uses standard SQL syntax, but doesn't have all the features that MSSQL has, which is why its considered a very fast, lightweight database, appropriate for many web applications

For more comparison info see my post at http://www.devshed.com/Talk/Forums/...TML/000481.html