SitePoint Sponsor

User Tag List

Page 1 of 3 123 LastLast
Results 1 to 25 of 55
  1. #1
    SitePoint Addict matt_12511's Avatar
    Join Date
    Feb 2004
    Location
    Michigan
    Posts
    256
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server Vs. MySQL - need to make a decision

    Which one is a better fit for me? for the company I work for?

    Ok, I work for a non-profit company with 8 employee's. We are growing quickly and sell our material all over the country. We are expanding our online abilities to include online training and web conferencing. I am in charge of designing the new website. I will create my own shopping cart, as well as a database for online success stories.

    Our host offers two packages Windows 2003, and a Unix plan. Unix uses MySQL and Windows 2003 uses MS SQL Server.

    Which is easier to use?
    Which is better to learn for my resume (selfish ) ?
    What direction is the web moving in? PHP/MySQL or ASP.NET/SQL Server?
    If I use SQL Server do I need to buy an expensive client SQL Server from Microsoft so that I can use SQL Server or is it a cheap/free download?

    What are your opinions?

    Thanks all,

    Matt

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    "Which is easier to use?"

    depends on how many other databases you already know

    if none, SQL Server


    "Which is better to learn for my resume (selfish ) ?"

    the obvious answer is: SQL Server

    it is closer to the sql standard, and so your skills will be more easily transferred


    "What direction is the web moving in? PHP/MySQL or ASP.NET/SQL Server?":

    coldfusion/postgresql


    "If I use SQL Server do I need to buy an expensive client SQL Server from Microsoft so that I can use SQL Server or is it a cheap/free download?"

    MSDE is free, and it does all you need (for development and testing)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict matt_12511's Avatar
    Join Date
    Feb 2004
    Location
    Michigan
    Posts
    256
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you for your informative response. I had never heard of PostgreSQL before.

    I am interested in hearing other peoples comments as well.

    Matt

  4. #4
    SitePoint Enthusiast
    Join Date
    Feb 2004
    Location
    Milkyway
    Posts
    31
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi, as far as I know you can destribute MSDE with applications althogh it has some restrictions like 2gb DB etc.
    "Money it's not everything!... There's gold, diamonds, etc..."

  5. #5
    SitePoint Enthusiast
    Join Date
    Feb 2004
    Location
    Tennessee
    Posts
    99
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by matt_12511
    Which is easier to use?
    MySql using phpMyAdmin . PostGreSQL works similar.

    Quote Originally Posted by matt_12511
    Which is better to learn for my resume (selfish ) ?
    Depends on your other qualifications.
    MS-SQL for non web related jobs.
    MySql/PostgreSQL for internet or freelance job or management

    Quote Originally Posted by matt_12511
    What direction is the web moving in? PHP/MySQL or ASP.NET/SQL Server?
    Apache+PHP+MySql - see netcraft.com

    Quote Originally Posted by matt_12511
    If I use SQL Server do I need to buy an expensive client SQL Server from Microsoft so that I can use SQL Server or is it a cheap/free download?
    Free for development. Limited connections to server.
    Full licence for production live environment.

  6. #6
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by sadcox66
    [as to what direction the web is moving in]
    Apache+PHP+MySql - see netcraft.com
    You are looking strictly at quantity when looking at those figures. As jeffyjones pointed out in a another thread, those figures accounts for hundreds of thousands of parked domains that are hardly sites, let alone "applications." Remember that IIS is running 43% of the top 1,000 trafficked sites on the Internet. Apache is 39%. That tells a more important story to me as far as identifying the most popular application platform.
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  7. #7
    SitePoint Evangelist
    Join Date
    Nov 2002
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by matt_12511

    Which is easier to use?
    Which is better to learn for my resume (selfish ) ?
    What direction is the web moving in? PHP/MySQL or ASP.NET/SQL Server?
    If I use SQL Server do I need to buy an expensive client SQL Server from Microsoft so that I can use SQL Server or is it a cheap/free download?
    MS SQL Server is user-friendlier and it's real enterprise level database; MySQL doesn't come even close to it if you compare them by features.

    For your resume is better to learn MS SQL (you can get paid twice as much with MS SQL versus MySQL), all big businesses use MS SQL or Oracle, not MySQL.

    ASP.NET is object oriented environment and you can write re-usable code there. ASP.NET applications are compiled, while the PHP are interpret on the fly, so ASP.NET is more scalable and faster.

    In short, choose MS platform

  8. #8
    Non-Member coo_t2's Avatar
    Join Date
    Feb 2003
    Location
    Dog Street
    Posts
    1,819
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by asp-hosting.ca
    MS SQL Server is user-friendlier and it's real enterprise level database; MySQL doesn't come even close to it if you compare them by features.
    How does PostgreSQL compare to MS SQL?
    It seems most DB guru types think PostgreSQL is much superior to MySql, so how does it stack up to MS SQL?

    --ed

  9. #9
    SitePoint Evangelist
    Join Date
    Nov 2002
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by coo_t2
    How does PostgreSQL compare to MS SQL?
    It seems most DB guru types think PostgreSQL is much superior to MySql, so how does it stack up to MS SQL?

    --ed
    MS SQL Server is much better choice

  10. #10
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by asp-hosting.ca
    MS SQL Server is much better choice
    strike two...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  11. #11
    SitePoint Member
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why is MS SQL better than PostgreSQL? I thought they had the same feature set. MS SQL might have better clustering support, but if you don't need that then why pay for it. I also think PostgreSQL might be more open, in the fact that you can write stored procedures in numerous languages rather than just T SQL, it's open source and from my expirience open source apps generally have numerous add ons or modifications that people have given away.

  12. #12
    SitePoint Addict matt_12511's Avatar
    Join Date
    Feb 2004
    Location
    Michigan
    Posts
    256
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well my host only has three options. I can use a windows 2003 server with MS SQL Server 2000, a UNIX server with MySQL, or Windows 2003 server with MS Access.
    I think I need a more powerful database to run the company online catalog. I think Access would work but when you consider all the security, reliability, etc... a high end database is probably worth the extra cash.

    So far the answer seems to be that MS SQL Server has more options and is easier to use (for beginners) than MySQL, but it will cost more. The host charges about $25 a month more for the Windows Server vs the UNIX server.

    Since Hostway will be hosting the database and I can download a free client to work with the database (right?), the added cost of $25/mo seems fair for the advantages. Am I right?

    Matt

  13. #13
    SitePoint Evangelist
    Join Date
    Nov 2002
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by matt_12511
    Since Hostway will be hosting the database and I can download a free client to work with the database (right?), the added cost of $25/mo seems fair for the advantages. Am I right?

    Matt
    You can download a free MS SQL web adiministration tool here:

    http://www.microsoft.com/downloads/d...displaylang=en

  14. #14
    SitePoint Wizard Young Twig's Avatar
    Join Date
    Dec 2003
    Location
    Albany, New York
    Posts
    1,355
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I thought ASP.NET and MSSQL were becoming most popular. I was looking at job opportunities on careerbuilder.com the other day (for an 8th grade career research report) and about 75-80% of the jobs required experience in ASP.NET/MSSQL. About 10% required PHP/MySQL. I don't see any that required ColdFusion/PostgreSQL.

    On the other hand, I don't know anything.

  15. #15
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Young Twig
    I don't see any that required ColdFusion/PostgreSQL.
    that's because it's a secret

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  16. #16
    SitePoint Enthusiast
    Join Date
    Jun 2003
    Location
    JodoHost.com
    Posts
    88
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm sorry, but I do not know how in anyway you can compare MySQL with SQL Server. MySQL can't match SQL Server in either performance or features.

    PostgreSQL does come close to SQL Server but it still lacks in many areas. There are still features that PostgreSQL does not support and SQL Server can handle load better especially in cluster and multi-processor environemnts.

    There is a reason why Microsoft SQL Server is expensive

    And these days, you can find plenty of inexpensive hosts that support SQL Server. The reason is that Microsoft has a total different licensing scheme for service providers where you could license a copy of MS SQL standard 1 procesor for little under $200/month
    Yash, CTO/Co-founder - JodoHost.com
    Sales: 1-888-289-2246 | Introducing Oracle10g Hosting!
    Windows 2003 | Cold Fusion MX | SQL Server | ASP.NET
    MultiPlatform Reseller Plans (Windows/Linux/VPS)

  17. #17
    SitePoint Evangelist
    Join Date
    Nov 2002
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by JodoHost
    I'm sorry, but I do not know how in anyway you can compare MySQL with SQL Server. MySQL can't match SQL Server in either performance or features.

    PostgreSQL does come close to SQL Server but it still lacks in many areas. There are still features that PostgreSQL does not support and SQL Server can handle load better especially in cluster and multi-processor environemnts.

    There is a reason why Microsoft SQL Server is expensive

    And these days, you can find plenty of inexpensive hosts that support SQL Server. The reason is that Microsoft has a total different licensing scheme for service providers where you could license a copy of MS SQL standard 1 procesor for little under $200/month
    Wise words

  18. #18
    SitePoint Addict
    Join Date
    Jul 2002
    Location
    Sooner Nation
    Posts
    208
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why does no one suggest Oracle?
    The only function of business is to create customer value and to innovate. - Peter Drucker

  19. #19
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,347
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by soonerdm
    Why does no one suggest Oracle?
    because none of us can stand larry ellison

    http://www.zpub.com/un/un-le.html
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  20. #20
    SitePoint Zealot Digitalman's Avatar
    Join Date
    May 2004
    Location
    Belgium
    Posts
    145
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Combined with the power of PHP, MySQL is the best choice.

  21. #21
    The Mind's I ® silver trophy Dark Tranquility's Avatar
    Join Date
    Sep 2003
    Location
    KSA - UAE
    Posts
    9,457
    Mentioned
    8 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by Digitalman
    Combined with the power of PHP, MySQL is the best choice.
    did u read what was written above ? I think it is clear that SQL Server is better than MySQL, it is even better than PostGreSQL !

  22. #22
    SitePoint Evangelist ghurtado's Avatar
    Join Date
    Sep 2003
    Location
    Wixom, Michigan
    Posts
    591
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't think thats clear at all. It is incredibly simplistic to say that " SQL Server is better than MySQL ", just like that. In these types of comparisons, absolute statements such as that one are often made due to lack of knowledge about either technology. There are many situations for many corporations (And not just small companies) where MySQL might just be "better" than SQL Server, specially if Linux or PHP are in the mix.

    Be careful with absolute statements!
    Garcia

  23. #23
    SitePoint Enthusiast ckaspar's Avatar
    Join Date
    May 2003
    Location
    Long Beach
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think that in a effort to appease everybody the more accurate answer to what is better would be whatever you feel more comfortable with.

    They all have their own intricacies. If you feel comfortable with MS go with SQL Server and ASP.net If you feel better with Open Source go with MySQL and PHP.

    For me the decision is based on what I have and what I am looking to do in the long run.

    If I do not have a lot of time then I go with ASP.net as I am more familiar with MS structures and logic. If I have some time to "play" them I go with OS. It is all up to you.

    I have spent so much time reading through forums trying to make the same determination as which is better and have come to the conclusion stated above.

    IMHO, a lot of people think that THEIR way is best and won't veer from what they know.

    I have made it a mission to learn all that I can about everything out there. I am willing to give everything a chance. I suggest you do the same.
    http://www.twintowntreatmentcenters.com

  24. #24
    The Mind's I ® silver trophy Dark Tranquility's Avatar
    Join Date
    Sep 2003
    Location
    KSA - UAE
    Posts
    9,457
    Mentioned
    8 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by ghurtado
    Be careful with absolute statements!
    ...well I have to say that I agree with this statement ain't it an absolute one ??

  25. #25
    SitePoint Evangelist ghurtado's Avatar
    Join Date
    Sep 2003
    Location
    Wixom, Michigan
    Posts
    591
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yup
    Garcia


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
  •