1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Access to MS SQL upload

Discussion in 'Business Applications' started by CFausch, Apr 5, 2010.

Thread Status:
Not open for further replies.
  1. CFausch

    CFausch Thread Starter

    Joined:
    Mar 3, 2010
    Messages:
    2
    We have a local database to gather data on various machines in the company. We have a direct SQL link to the MS SQL server on our local machines, but we can't carry around laptops all day while going form machine to machine due to space and battery constraints, so the local version of the database runs on each machine from a flash drive and is later uploaded to the SQL server.

    The issue comes in when the uploads are done from offsite locations to the SQL server. We have a fairly wide pipe to our data center (you can get a 10-15 mb file in a couple seconds more often than not. When uploading from the local Access DB to the SQL server in the data center (on a gigabit link), the appending of new data takes about 5 minutes, and checking existing data against the data in the database takes about 7.5-8 minutes.

    When offsite, at the same locations that can move 10+mbps, the appends take 30-45 minutes and the cross-check takes 1-1.5 hours. What is it about access/MSSQL that causes this throttling issue on an otherwise wide enough pipe?
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/914913

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice