Can't Decide - Access or SQL Server...

Discussion in 'Databases' started by vys, May 19, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. vys

    vys

    Hi,

    I?m currently in the design phase for my current project ? haven?t written any code, just a bunch of paper so far.

    The project is this?I want to have a website which I will be entering billing data into daily and I want the customer to log into the website if they want to check their balance.

    Currently the data is in FIlemaker Pro. The current table with the customer?s information in it has only 1000 records or so. The table with the transactions in it currently exceeds 80,000 records. Roughly 3000 new records are added monthly.

    I know SQL2005 could easily handle the load and would be bulletproof, but would an Access database be a better choice? I ask this only because I could upload it daily rather than using a ton of bandwidth whenever a customer calls me for their account balance or when I enter new transactions.

    If I were to use local web page or application which gets data from the Discount ASP.NET SQL server is this going to use up any of my monthly bandwidth?

    As you can tell my main issue is bandwidth usage.

    Also can you back up or restore MS SQL data on Discount ASP.NET servers?

    I appreciate any help you can give me.

    Thanks.
     
    vys, May 19, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    I highly recommend using MS SQL rather than MS Access.

    With MS SQL, you can connect to our server with any SQL client where you can make changes to your database.

    With Access, the problems are

    1) It can crap out under load

    2) The DB can be locked when you upload a new copy causing corrupted data. This will not happen w/ SQL.

    > If I were to use local web page or application which gets data from the Discount ASP.NET SQL server is this going to use up any of my monthly bandwidth?

    No. We do not currently charge for SQL bandwidth

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, May 19, 2006
    #2
  3. vys

    vys

    Thanks for the reply. I will definately go with SQL.

    How would I go about backing up the SQL data on the Discount ASP.NET servers?

    As it has all of my customer data (which I need to make a living) it is important for me to be able to have a hard copy of my customers on a disk.

    Thanks.
     
    vys, May 19, 2006
    #3
  4. J.Bey

    J.Bey

    J.Bey, May 24, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page