SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    I'm a college yuppie now! sbdi's Avatar
    Join Date
    Jul 2000
    Location
    Dublin , Ireland
    Posts
    1,271
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL vs SQL server

    Ok leave out the whole open source, free or microsoft argument

    Imagine both databases cost the same price which would you choose ?

    I have some guy saying MySQL is better then SQL which I simply cannot believe as SQL server doesnt come cheap and it seems to be used by a few e-commerce sites.
    Back Again

  2. #2
    SitePoint Addict
    Join Date
    Feb 2001
    Posts
    302
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL server is far in a way the better DB out the two, why?

    - transactions
    - stored procedures
    - foriegn keys
    - triggers

  3. #3
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by neil100
    SQL server is far in a way the better DB out the two, why?

    - transactions
    - stored procedures
    - foriegn keys
    - triggers
    Yes, but only if you need those features. If you don't, MySQL is perfect as it is fast and available on pretty much every host and can easily be installed on your own computer

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Imagine both databases cost the same price which would you choose?
    sql/server, in a new york minute

    there's no comparison, sql/server is an industrial strength database and mysql isn't
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,121
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I'd have to agree. They really don't compare. If all you need is a small fast database, then MySQL is perfect. If you need robust, enterprise level then it's left in the dust and SQL Server stands proud
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  6. #6
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,301
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    doesn't mySql do stored procedures? i've never used it, but thought it did.

  7. #7
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nope, it is supposed to be added sometime though

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •