What is the difference between MySQL and MSSQL

Discussion in 'MySQL' started by hansab, Feb 3, 2010.

0
  1. #1
    I would like to know the difference between mysql and mssql.

    I am currently using ASP for web, but switching to PHP very soon hopefully, which db is good for me and what is the difference.

    For practice i will use this db on my home pc, which has windows xp, so how do i install mysql so it can work with asp and php as well.

    Please advice.
    Regards
     
    hansab, Feb 3, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Definitely MySQL.

    It works on both Linux and Windows, something that MSSQL does not. It's free, it's well supported, and unless you need some of the more advanced features, it's a perfectly suitable replacement for MSSQL.

    The exception is if you need to do a lot of replication, or some MSSQL only feature, and you have an unlimited budget. MSSQL is way ahead of MySQL for replication and management, and some more advanced features, however 99% of users don't need these.
     
    jestep, Feb 3, 2010 IP