Source language: Translate to:

Synchronizing database

Questions about NeoBook PlugIns

Moderator: Neosoft Support

Synchronizing database

Postby Kevin McGinley » Thu Feb 22, 2007 5:44 pm

How would one go about synchronizing two databases created with NeoBook DB plug-in. I have been thinking about it and I cannot wrap my mind around how to even begin. Any thoughts or has anyone already solved this issue?

Thanks.

Kevin
Kevin McGinley
 
Posts: 5
Joined: Mon Jul 24, 2006 7:14 pm

Postby Gaev » Thu Feb 22, 2007 6:07 pm

Kevin:

Perhaps you need to define synchronizing first ... say you want to sync. dbfA and dbfB ...

a) do you just want to sync. dbfA using dbfB ? ... or also sync. dbfB using dbfA ? ... if the latter, you will need to have some kind of timestamp data in the records to identify precendence.

b) do they both have identical fields (including field types) ?

c) can records be identified via a unique key ?

d) the actual logic will depend on your exact definition of synchronization ... but things to consider are ...

- records in dbfA and dbfB with different content
- records in dbfA but not in dbfB
- records in dbfB but not in dbfA

... the last two can be tricky ... as you could end up undeleting previously deleted records ... i.e. if record with key=1234 exists on dbfA but not on dbfB ... is it because it was deleted from dbfB or because it was added to dbfA ? ... and so do you add it to dbfB or remove it from dbfA ?
User avatar
Gaev
 
Posts: 3734
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada


Return to PlugIn Discussions

Who is online

Users browsing this forum: No registered users and 1 guest

cron