Load tables to the local drive

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Malvina (anonymous_at_discussions.microsoft.com)
Date: 03/26/04


Date: Fri, 26 Mar 2004 12:06:02 -0800

I would like to create a mechanism, where on opening the
database from the server, all my tables would be loaded to
the user's local drive. When the user closes the db all
the updates have to go back to server. The reason for me
doing that is, because the traffic on the server is so
bad, and the process of navigating within the db is VERY
SLOW.
I can visualize that it's possible, but I need to figure
out how and where to start. May be some simple code, or
example.

Thank you for the reply in advance,
Malvina



Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)