Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    Scotland
    Posts
    1

    What database to use?

    I am building a site on an Intranet using a database. There will be upwards of 25000 records in the database.

    I am familiar with using Access, but someone recommended I use SQL Server. Can anyone suggest what the best option is?

    Thanks,

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if those are your only two choices, and if both are available on your intranet, go with sql server

    rudy

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: What database to use?

    Originally posted by twave
    I am building a site on an Intranet using a database. There will be upwards of 25000 records in the database.

    I am familiar with using Access, but someone recommended I use SQL Server. Can anyone suggest what the best option is?

    Thanks,
    Access is not intended for multi-user applications, it is essentially a personal database.
    This Microsoft article goes into more detail:
    http://support.microsoft.com/default...;en-us;q222135

  4. #4
    Join Date
    Dec 2002
    Posts
    65
    If you have access to a *nix box, then I'd recommend giving PostgreSQL a try. It's free, feature rich, tries to adhere to standards, and is dependable. I am currently using PostGres now for my company's intranet which has over 300,000 records.

    Then again I haven't worked with DB2 or Oracle since I've never had the budget for something like that, but for only 25,000 records I'd say that might be overkill.

    my 2 cents,
    -b
    (I'm only available at the email address provided in my profile on weekdays, if you have questions or advice, during off hours use AIM). Also any views I provide here or on my website are mine and not representative of any views of my work, family, friends and sometimes even myself.

    http://www.bcyde.com

Posting Permissions

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