Subject Re: synchronize data database tables
Author petesouthwest
Hi

As I said in my original post: My app will be used on users' home
machines as well as a LAN at work and I need to be able to allow
them to easly 'transfer' the work ie data they have added and
amended, back and forth. It needs to be a routine that allows them
to select their file and then updates only the records they have
modeified or added automaticaly leaving existing data untouched.

In the past I have done this by allowing them to export the data to
a CSV file of their choice and then import it back. I did this using
SMI components that were reasonable priced. However, this involved
mapping columns which seems long and error prone for a lot of tables
with a lot of fields.

Is there a better, easier way of doing it?

Thanks
Pete


--- In firebird-support@yahoogroups.com, "Myles Wakeham"
<myles@t...> wrote:
> You probably need to explain exactly what you are trying to
achieve here.
> The term 'synchronization' means a lot of different things to
different
> people. If you could explain your requirements in more detail, we
could
> probably help you better.
>
> Regards,
> Myles
>
> ===========================
> Myles Wakeham
> Director of Engineering
> Tech Solutions Inc.
> Scottsdale, Arizona USA
> Phone (480) 451-7440
> Web: www.techsol.org
>
>
> > -----Original Message-----
> > From: petesouthwest [mailto:petesouthwest@h...]
> > Sent: Thursday, August 26, 2004 9:06 AM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] Re: synchronize data database tables
> >
> > Hi
> >
> > I'm looking at the IBOtools stuff but it talks alot about
creating
> > tables etc. I dont really want to save information about the
> > structure of the database, all my users need is to be able to
> > transfere data via a flopy or email, so it wants to be a small
file
> > size.
> >
> > Not sure if the help is saying the TIB_RPL_Meta object do that?
The
> > examples seem complex compared with what I am trying to achieve.
> >
> > Pete
> >
> >
> >
> >
> > --- In firebird-support@yahoogroups.com, Andy Goodchild
> > <goodieauk@y...> wrote:
> > > petesouthwest wrote:
> > >
> > > >
> > > > Is there an easy way to allow several users to synchronize
the
> > data
> > > > in database tables?
> > >
> > > I guess you are looking for some form of database Replication.
> > > Have a look at:
> > > http://www.ibphoenix.com/main.nfs?
a=ibphoenix&page=ibp_repl_tools
> > > For some examples.
> > > If you want more information on Replication search the
IBPhoenix
> > site it
> > > has a number of good papers on it.
> > > If you are new to replication I would read these before trying
to
> > > determine which is the best tool for you to use.
> > > I have used IBReplicator in the past of Interbase and Firebird
> > Sites and
> > > it works okay.
> > >
> > > Regards
> > > Andy
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >