SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2002
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question SQL Server v MySQL

    Hi there, can someone tell me what the differences between SQLServer and MySQL are.

    I'm presuming MySQL is just a cut down version of SQLServer (oh and its free !) but what are the actual differences. What can i do in SQL that i can't do in MySQL.

    I have a project to research and work are too tight to give me a copy of SQL to take home with me (although it will be SQL that i will do the work on eventually).

    Any help would be greatly appreciated.

    Cheers

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    they are totally different products

    totally

    the only thing they have in common is that they both claim to support the relational database model through the so-called standard SQL language

    but both have wildly different proprietary extensions to that language

    suggesting that MySQL and SQL Server are the same is like suggesting that Apple and Wintel computers are the same

    at some nebulous level of abstraction, they are

    but not where it matters


    rudy

  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)
    Perhaps you can tell us about the project and we can suggest suitable software

    Sean
    Harry Potter

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

  4. #4
    SitePoint Enthusiast
    Join Date
    Oct 2002
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Funnily enough, i don't know too much about the project. All i know is that involves a database and a web interface for people to compare data.
    The database will be SQL Server and alot of the programming done in VB.NET

    I'm meeting the people that have started the project to find out what they have done so far. I didn't want to appear stupid when i met them so thought I should brush up on all things databasey (this is my first development project).

    I couldn't get a copy of SQL server, so i was going to download a copy of MySQL and go from there.

    I'm thinking now though, that maybe if i just brush up on the SQL Language and database structure in general, that may suffice for now.

    When i join the project and get stuck on SQL, i know where to come for advice... )
    Thanks for the info so far though.

  5. #5
    SitePoint Enthusiast
    Join Date
    Oct 2002
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That should have been a smiley at the end of that sentence - that will teach me to draw my own smiley face instead of selecting one !!

  6. #6
    SitePoint Enthusiast tripp's Avatar
    Join Date
    Dec 2002
    Location
    Austin, TX USA
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can get a six-month trial version of SQL Server for evaluation purposes: http://www.microsoft.com/sql/evaluat...al/default.asp

    It comes with the Server Tools, so you can use Enterprise Manager and Query Analyzer to set up and manage your databases.

  7. #7
    SitePoint Enthusiast
    Join Date
    Oct 2002
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Tripp, i'll give it a go.


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
  •