SitePoint Sponsor

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 25 of 28
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL or SQl Server

    I am a student and I am gonna have to do my project soon, the class I am talking is called DB Design, we have to implement it in either MySQl or SQL server, can someone tell me what are the differences and benefits? Thanks
    Maternity.com Ultimate Source for Expecting Parents and Parents

  2. #2
    SitePoint Zealot dawgbone's Avatar
    Join Date
    Dec 2003
    Location
    Brampton
    Posts
    198
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I personally use MySQL.

    The honest reason is that when I was looking around, it was much easier to install and run than SQL server was.

    The step by step instructions were a breeze, and there are multiple programs you can use to do your SQL queries on. SQL server, from what I was reading, wasn't nearly as flexible.

    Read the sitepoint book on php and MySQL... well, at least the chapters that are available on the net, it gives a great breakdown of how to install MySQL on your computer or server (under Windows, Unix-based, and OS-X).

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    CrazyMod, if you have to install the software yourself, good luck

    but if all you have to do is access one or the other of two already existing database servers on the campus network, then, dude, go for sql server, the design options, relational integrity, and sql flexibility are much, much better than mysql
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937
    CrazyMod, if you have to install the software yourself, good luck

    but if all you have to do is access one or the other of two already existing database servers on the campus network, then, dude, go for sql server, the design options, relational integrity, and sql flexibility are much, much better than mysql
    We have MySQL Server installed in the lab, I have MySQL installed on my server, I am little familiar with PHP but i never done anything on SQL Server, will the code actaully has to be different? or they are the same for both?
    Maternity.com Ultimate Source for Expecting Parents and Parents

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    the code is different enough

    go with mysql, you have a head start
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Do you have to implement Database Design or do you have to set up pages in a server side language like ASP or PHP to query the database?

    If its the first scenario, then I agree with Rudy, go with SQL Server, nothing beats its ease when it comes to designing & implementing databases.
    It has all of it in a GUI built within it, so there's no problem in managing it.
    MySQL on the other hand is more of a command line thing, & you have to depend on 3rd party tools for getting the GUI.
    If its the secon scenario, then all of it depends on what language you are using. If you are using PHP, then there's no better choice than MySQL. If you are using ASP, then SQL Server is best. If you are using Java, then you can go for MySQL or Oracle.

    If you already have MySQL & know a bit about it & you are in a rush, then I suggest go with MySQL. Otherwise, if you have time, you can spend some of it fooling around SQL Server, you'll get the hang of it in no time.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  7. #7
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thank you, those are very helpful. I have to implement DB design, we had to start out with IDEFX1 Standard model, data dictionary and things like that, soon will be implementation. I am just kinda confused , you know, technically, the porject is kinda like an intern project, we have to design a DB for a community hospital, expected many relationships and suchs. Someone mention
    relational integrity, and sql flexibility are much, much better than mysql
    , it sounds like i need it but I have no idea in ASP( I only work on PHP before), actually the project doesnt even require it has to be the web interface, i just think it may be easier for me to do everything by the web since some patient registration forms are must.
    Maternity.com Ultimate Source for Expecting Parents and Parents

  8. #8
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Using SQL Server doesn't mean that you have to use ASP only. Its just that ASP is preferred b'coz of ADO which is much much better than ODBC. Otherwise you can also use PHP & use ODBC to connect to SQL Server, no problem in that.

    Also, MySQL can handle relationships & entities etc well enough too, its just a matter of what you find easy. For me, I find SQL Server much easier with its point & click interface.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  9. #9
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by asp_funda
    Using SQL Server doesn't mean that you have to use ASP only. Its just that ASP is preferred b'coz of ADO which is much much better than ODBC. Otherwise you can also use PHP & use ODBC to connect to SQL Server, no problem in that.

    Also, MySQL can handle relationships & entities etc well enough too, its just a matter of what you find easy. For me, I find SQL Server much easier with its point & click interface.
    is there a way I can practice, like with PHP and MySQL, you can actually install a vituarl Apache and localhost on windows XP( http://localhost) , so you can practice it, can I do it with MyQSL server too?
    Maternity.com Ultimate Source for Expecting Parents and Parents

  10. #10
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Yes, you can practice that too, I mean PHP & SQL Server. You just need to install SQL Server on your machine & if PHP & a webserver(IIS/Apache) is installed, then you are ready to go, no problem.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  11. #11
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by asp_funda
    Yes, you can practice that too, I mean PHP & SQL Server. You just need to install SQL Server on your machine & if PHP & a webserver(IIS/Apache) is installed, then you are ready to go, no problem.
    I am using Minixamp to install apache server on my comp, it does all teh configuring jobs for you, all you need to do is run .bat file, here is the link
    http://www.apachefriends.org/xampp-windows-en.html

    so how do i find any freeware or software that do the same thing for SQL Server?
    Maternity.com Ultimate Source for Expecting Parents and Parents

  12. #12
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Nothing like that for SQL Server & its not free either. You have to buy SQL Server.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  13. #13
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There always is MSDE...

  14. #14
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    also, its not difficult to install SQL Server. Its easy enough. Its a wizard that takes you through installation & just select the default settings, & make sure you read & understand the options before choosing them or clicking the NEXT button.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  15. #15
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by dhtmlgod
    There always is MSDE...
    ????
    Maternity.com Ultimate Source for Expecting Parents and Parents

  16. #16
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by dhtmlgod
    There always is MSDE...
    Yeah sure, forgot about that.
    Also, I think that there's a 30day trial for SQL Server2000.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  17. #17
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by CrazyMod
    ????
    MSDE stands for Microsoft SQL Desktop Edition(I think that's what its full-form is). Its a free edition of SQL Server, but it only allows you to create databases etc & manipulate them through your server side language.
    I haven't used one, so I don't know what exactly it has & what it doesn't.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  18. #18
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  19. #19
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can do everything throught command line, and I think ASP.NET Web Matrix can connect to it.

  20. #20
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    But he's gonna use PHP to connect to SQL Server/MSDE through ODBC. I don't think that WebMatrix would do in this scenario.

    But if he has MS-Access installed, he can open up the database in that using ODBC. That'll give him GUI for entering data in the tables(can't create them though) & I think that making relations between tables too.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  21. #21
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,576
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Pfft-pfft . . .

    There are 2 methods to get a GUI on MSDE. First is to use an access data project connected to a db. Second is to dl the 90 day trial version of MSSQL, then install the client tools. The server will timeout, but the client tools are forever. Then add a registration for your MSDE DB and you are off to the races.

    WWB

  22. #22
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by wwb_99
    Pfft-pfft . . .

    There are 2 methods to get a GUI on MSDE. First is to use an access data project connected to a db. Second is to dl the 90 day trial version of MSSQL, then install the client tools. The server will timeout, but the client tools are forever. Then add a registration for your MSDE DB and you are off to the races.

    WWB
    Ok so below is what I need to get and install, step by step

    -Download Trial Version SQL Server 2000
    -Download MSDE
    -Download MSSQL
    - then now I am confused LOL, whats is GUI by the way?
    Maternity.com Ultimate Source for Expecting Parents and Parents

  23. #23
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,236
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    If I were you I'd just install the trial version of SQL Server 2000, especially if this is just for a school project (you'll be done in less than 120-180 days right?).

  24. #24
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,479
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by CrazyMod
    Ok so below is what I need to get and install, step by step

    -Download Trial Version SQL Server 2000
    -Download MSDE
    -Download MSSQL
    - then now I am confused LOL, whats is GUI by the way?
    SQL Server 2000 & MSSQL is same, not 2 different things.

    And I agree with Vinnie, if you just need this for the school project, it will take less than 90days I think, which is the trial period of the SQL Server 2000. If yes, then just install full SQL Server 2000, both client tools as well as the server.

    Also, if you need a little more time, just set your system clock 7 months back, when the SQL Server trial expires & install it again.
    Just hope that you don't need to resort to this trick.
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!

  25. #25
    SitePoint Zealot
    Join Date
    Dec 2003
    Location
    SF
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can I install SQL server on my own desktop using window XP? if yes what version? Standard or Enterprise?
    Maternity.com Ultimate Source for Expecting Parents and Parents


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
  •