difference mysql and ms sql

Discussion in 'Databases' started by aman_gcs, May 9, 2011.

0
  1. #1
    compare mysql and ms sql?
     
    aman_gcs, May 9, 2011 IP
  2. ken.sweet

    ken.sweet Active Member

    Messages:
    683
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    93
    #2
    my sql is an open source database and can be used on any platform like windows,linux or mac. It is much easier to use.
    ms sql is a windows based database which can be used only on windows and is quite tuff to learn.
     
    ken.sweet, May 9, 2011 IP
  3. randheer

    randheer Greenhorn

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #3
    My SQL is open source database while MS SQL Server is micrsoft product. MY sql has limited facilites while sql server is very advance and having many other features like ETL , Reportic and Anlytics.
     
    randheer, May 9, 2011 IP
  4. om39a

    om39a Peon

    Messages:
    287
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Technical - As of versions 4.x MySQL does not support views, triggers, stored procedures, user defined functions, XML, while all these are supported by MS-SQL

    Non Technical - MS SQL is an expensive (*relatively*) proprietary RDBMS developed & owned by Microsoft Corporation while MySql is an open source RDBMS developed & maintained by MySQL AB of Sweden with free as well as paid enterprise versions available.

    Source: geekpoint.net
     
    om39a, May 11, 2011 IP
  5. aman_gcs

    aman_gcs Member

    Messages:
    178
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #5
    thanks for share the information
     
    aman_gcs, May 12, 2011 IP
  6. williamsadrina

    williamsadrina Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    hi,

    Mainly the applications are supported by MYSQL whereas MSSQL mostly supports Windows based applications only. If someone is looking for SQL database for an application which is not a Windows based application like PHP, HTML or any other, then I would suggest MYSQL as it is better for this purpose.

    Thanks!
     
    williamsadrina, May 12, 2011 IP
  7. yester123

    yester123 Peon

    Messages:
    360
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #7
    MySql is a type of data base which is compatible with linux, windows, etc

    where as MS Sql is compatible only with windows.
     
    yester123, May 13, 2011 IP
  8. RonBrown

    RonBrown Well-Known Member

    Messages:
    934
    Likes Received:
    55
    Best Answers:
    4
    Trophy Points:
    105
    #8
    Apart from some obvious bias here which I'll ignore, MS SQL is available as a free version too as MS SQL Express. It has most of the functionality of the more expensive versions, has a free mananagment tool (Sql Server Management Studio) and is enterprise-class in its abilities. If you have a choice of what DB server to use because you aren't constrained by your operating system, then MS SQL 2008 Express is a superior product.
     
    RonBrown, May 14, 2011 IP
  9. b10

    b10 Peon

    Messages:
    755
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    absolute correct difference btn sql & mysql thanks
     
    b10, May 31, 2011 IP
  10. RonBrown

    RonBrown Well-Known Member

    Messages:
    934
    Likes Received:
    55
    Best Answers:
    4
    Trophy Points:
    105
    #10
    MySQL was bought by Sun Micro in 2008, and has been owned by Oracle since 2010, not that this makes much difference to the OP but AB have been out of the picture for a long time.
     
    RonBrown, Jun 1, 2011 IP
  11. tothemax

    tothemax Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    MS SQL was actually initially forked from Sybase, which is still used a bit in the high end financial scene. They share a very bascially the same stored procedure language called T-SQL or Transact SQL
     
    tothemax, Jun 6, 2011 IP
  12. amkeabhi123

    amkeabhi123 Member

    Messages:
    219
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #12
    the difference between my sql and mssql ,these used in programming language because mysql used any plate from when ever mssql used only window
     
    amkeabhi123, Jun 21, 2011 IP