#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Ocean State
    Posts
    6
    Rep Power
    0

    server/database advice


    Setting up a half-dozen database driven sites on a Windows 2000 Advanced server, and I need some advice on what type of set up to use. I have very limited experience with MySQL, but would SQL Server be easier to work with? Perhaps there is something else that I'm not aware of that might be even better?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    #devshed @ irc2.beyondirc.net
    Posts
    231
    Rep Power
    12
    If you have more experience with SQL server, and the resources to run it for all those web sites, it might be a better solution for you than MySql. Mysql is free of course, which is an advantage, but SQL server definitely has some advantages over Mysql. So, it also depends a lot on the requirements of these web sites.
    .
  4. #3
  5. Second highest poster :p
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jul 2001
    Posts
    7,322
    Rep Power
    33
    SQL server is VERY expensive... but does have some advantages over MySQL server. What I would use is PostgreSQL since it offers the same stability and more-or-less the same features as MS SQL. You can run PostgreSQL via Cygwin and many people do this. There is a native windows version of PostgreSQL but it is still in beta form.
    - Andreas Koepke

    Koepke Photography

  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2002
    Location
    DK
    Posts
    11
    Rep Power
    0
    I'm using SAP DB - the database made and supported by SAP in Germany.
    As far as I can tell it's more or less equal to Oracle and DB2.
    And it's free!
    www.sapdb.org

IMN logo majestic logo threadwatch logo seochat tools logo