When you have multiple instances of a database, and then try to merge the
updates on a regular interval, you will run into many tough questions such
as "Which is the master? How do you update each client site?" Assuming
each client site will not try to overwrite each other(a Big ASSUMPTION), you
can create a file with all the daily delta in a fixed format by making it
run at designated time, ftp over to the server. The server must be running a
program that detects the arrival of the file and apply it to its database.
If you want this to occur without human input, I'd suggest using Unix
(Linux) on both ends. To make this work without fail (You want to make it so
in business systems) will be a non-trivial task.
Good luck.
"Himansu" <m.himansu_at_sify.com> wrote in message
news:33194ce2.0202052248.31ef0b8b_at_posting.google.com...
> Hello !
>
> We have a system in which the same database is running in
> several Client machines(desktops) on Personal Oracle.
> We have another machine(say server)with the same database which is
> connected
> (through dial-up network connection) to each of the client machines
> in different times during the day.
> The need is to transfer all the new transactions to the database on
> the server
> from each of the client machines when the connection is on.
>
> One approach for this as I see is to send the dmp file(incremental
> export)
> to the server each time the connection is on and then to import this
> file on the server.
> But this involves manual work at both the ends.
>
> Is there any other way in which the transactions can be updated in the
> server
> without much of manual work involved ???
>
> I need the solution early, so need your comments/suggestions soon.
>
> Thank you in advance.
> Himansu
Received on Wed Feb 06 2002 - 09:16:05 CST
