synchronizing database with laptops

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have a database that we use to store data which is subsequently used as an
input for calculations in another software. Basically, it is an interface
which accepts inputs and produces an output txt file that is readable for a
DOS program.

I'd like this database to be mobile with our sales people in that they can
have a copy for on the road. I'd like for them to be able to add
information not change existing. What is the best way I could synchronize
the main computer in the office with the laptops so that we can easily
import the new information that is entered on the road?

One way is for them to note which new ones are entered, and import them
later but there must be a better way. I expect only about 5 / week being
entered on the road.
 
Have a quick read up on replication. Not used it myself, but the help
suggests it will do what you need, ie

"
Briefcase replication

Briefcase replication is perhaps the easiest way to implement replication
and is a convenient tool for keeping a database file up-to-date. You can
replicate the database on your laptop by using Briefcase replication,
disconnect the laptop from the network, and then make changes to the data in
the replica (replica: A copy of a database that is a member of a replica set
and can be synchronized with other replicas in the set. Changes to the data
in a replicated table in one replica are sent and applied to the other
replicas.). When you are finished working on the files on the laptop
computer, you can then reconnect to the network, and automatically
synchronize any changes between the database on your laptop and the Design
Master (Design Master: The only member of the replica set in which you can
make changes to the database structure that can be propagated to other
replicas.) on the network."
 
Back
Top