Re: Database synch

From: Katherine <ktlang_at_prodigy.com>
Date: Wed, 24 Apr 2002 07:05:37 GMT
Message-ID: <5Psx8.184$9a7.174144788@newssvr13.news.prodigy.com>

lucas:
it is difficult to provide a specific answer without fully analyzing the application structure.

however, look into creating triggers on the laptop to maintain log tables. each time a record is inserted, updated, or deleted, a record is inserted in the log table, which identifies the change. then, write an application that syncs the data between the master and laptop using these log tables.

"Lucas" <Lucas_44_at_hotmail.com> wrote in message news:Pkfx8.7752$dd7.582549_at_news0.telusplanet.net...
> Hi all,
>
> We have a system that the vendor downloads the current database from the
> server to a laptop. Changes are made on his laptop, what is
> the best way to upload this back to the server? Records are added,
modified
> and moved. Re-importing the whole database is not
> an option.
>
> Lucas
>
>
Received on Wed Apr 24 2002 - 02:05:37 CDT