filemaker sync
am 01.10.2007 20:57:58 von Shawn Hamzee
Is there anyway to sync several filemaker databases? I am using fm8 on tiger.
the files are served on different fm8 servers however, i need to sync these
files perhaps on a nightly basis.
thanks.
--
POST BY: lark with PHP News Reader
Re: filemaker sync
am 02.10.2007 18:59:16 von d-42
On Oct 1, 11:57 am, lark wrote:
> Is there anyway to sync several filemaker databases? I am using fm8 on tiger.
> the files are served on different fm8 servers however, i need to sync these
> files perhaps on a nightly basis.
> thanks.
> --
> POST BY: lark with PHP News Reader
Pretty much have to roll your own.
Mark new records as new. Mark modified records as modified. Mark
deleted records as deleted instead of deleting them.
Then when syncing, have each database import the others 'new' records,
update the others 'modified' records, and mark the deleted records
deleteds. Then once complete, delete the deleted records.
You'll also have to set policy and deal with the conflict resolution -
a record deleted in one but modified in another; or modified in
both... etc.
Life is considerably easier if you only have to sync new records or
have a master server that the others are slave to. e.g. if you
managing a price list; its easier to have head office maintain the
master, disallow branches from modifying it, and then you only have to
propogate changes from the master out; so their is no conflict
resolution to deal with; changes only happen at the master.
-cheers,
Dave
Re: filemaker sync
am 02.10.2007 19:37:01 von Lynn Allen
On 2007-10-02 09:59:16 -0700, d-42 said:
> On Oct 1, 11:57 am, lark wrote:
>> Is there anyway to sync several filemaker databases? I am using fm8 on tiger.
>> the files are served on different fm8 servers however, i need to sync these
>> files perhaps on a nightly basis.
>> thanks.
>> --
>> POST BY: lark with PHP News Reader
>
> Pretty much have to roll your own.
Or you could use: http://www.worldsync.com/syncdek/
Expensive? Yes. Worth it? I guess it depends on the value of your data,
your time, and having the synchronization be robust.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA
Re: filemaker sync
am 02.10.2007 23:53:31 von Shawn Hamzee
== Quote from Lynn Allen (lynn@NOT-semiotics.com)'s article
> On 2007-10-02 09:59:16 -0700, d-42 said:
> > On Oct 1, 11:57 am, lark wrote:
> >> Is there anyway to sync several filemaker databases? I am using fm8 on tiger.
> >> the files are served on different fm8 servers however, i need to sync these
> >> files perhaps on a nightly basis.
> >> thanks.
> >> --
> >> POST BY: lark with PHP News Reader
> >
> > Pretty much have to roll your own.
> Or you could use: http://www.worldsync.com/syncdek/
> Expensive? Yes. Worth it? I guess it depends on the value of your data,
> your time, and having the synchronization be robust.
aha, this was a good link. thanks for pointing it out.
--
POST BY: lark with PHP News Reader