best way to have a central database and remote can be portable

Question

Hi I´m trying to do a system that has a central database in the office and if necessary I work in a copy of the database out of the office and when i return i update the client(s) record.

I have for each client a master table dataset client========>Local places of this client===> Equipment====>Report(variables).

so when I return I have to Update the master table Insert or update the other dependent tables.

client  (Edit)
Local places (Edit or Insert or Delete)
Equipment (Edit or Insert or Delete)
Report(variables)(Edit or Insert or Delete)

Thank´s

Answer 1

The TClientDataset component provided with Delphi should provide the capabilities you need for that. Check the documentation for TClientDataset, especially the parts about using the "briefcase model" for temporary local storage of data. It's almost exactly what you're describing.

Answer 2

In addition to Mason's suggestion (the TClientDataset) which is a very good idea, you could consider using NexusDB, I'm pretty sure it supports something called Replication, which basically involves syncing changes between multiple (local+ remote, or two offices with their own databases) databases.

Answer 3

I currently use Asta (TAstaClientDataset) to suitcase my data (in office / off office). astatech.com has demo and tutoriels to show (suitcase.dpr). Works nice and fast for any database system.

Answer 4

So the simple way to solve my problem is to delete and append new field´s each time i want to update my server database!

something like this

Sub_TRelFinal.Post;
end;
  ADOTable_casa_sub_1.First;
Sub_TRelFinal_1.DisableControls;
DBGridEh4.SelectedRows.SelectAll;
DBGridEh4.SelectedRows.Delete;
 while not ADOTable_casa_sub_1.Eof do begin
begin
 Sub_TRelFinal_1.enableControls;
 Sub_TRelFinal_1.append;

because my master record is the index of my image folder \picture\123..............

or is there a simples way?

Thank´s