Thread: MySQL vs MS SQL

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    2
    Rep Power
    0
    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.
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    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/F...ML/000481.html

Similar Threads

  1. Replies: 3
    Last Post: January 28th, 2010, 03:14 PM
  2. Replies: 1
    Last Post: January 24th, 2004, 01:20 PM
  3. Replies: 0
    Last Post: December 30th, 2003, 01:57 PM
  4. SQL discrepancies MS-Access vs. MySQL
    By MarjaR in forum MySQL Help
    Replies: 1
    Last Post: September 30th, 2003, 02:08 PM
  5. Migrate Microsoft SQL to mySQL
    By packae in forum MySQL Help
    Replies: 2
    Last Post: December 15th, 2001, 04:07 PM

IMN logo majestic logo threadwatch logo seochat tools logo