🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #152

Synchronizng two databases?

#152
From: mdR
Date: Fri, 31 Mar 2006 13:22
18 lines
1913 bytes
Hi all,

Is there a fairly easy method for synchronizing two JDataStore
databases aside from iterating thru the records one by one and
comparing?

I have a home database and a copy of the same database at work.  I want
to be able to copy one of them, say the one at work, bring it home and
merge any additional record differences there may be.  I don't care
about records that may have been deleted, just records that may have
been added  from one to the other.

I have looked at the PumpAndSync example, but I think those components
simply copy the tables from source to target and would simply delete
records at the target.

tia
-mark
Technical Details
Message-ID: <1143811346.963289.6580@e56g2000cwe.googlegroups.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e56g2000cwe.googlegroups.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,9cc9ffab9753ec0f,start
X-Google-Thread: f7cf6,9cc9ffab9753ec0f,start
X-Google-Thread: f705a,9cc9ffab9753ec0f,start
X-Google-Attributes: gid1073da,gidf7cf6,gidf705a,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e56g2000cwe.googlegroups.com!not-for-mail
From: "mdR" <mrafn@lakenet.com>
Newsgroups: borland.public.jbuilder.database,borland.public.jdatastore,borland.public.jbuilder.jdatastore
Subject: Synchronizng two databases?
Date: 31 Mar 2006 05:22:27 -0800
Organization: http://groups.google.com
Lines: 19
Message-ID: <1143811346.963289.6580@e56g2000cwe.googlegroups.com>
NNTP-Posting-Host: 12.148.27.193
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1143811352 12089 127.0.0.1 (31 Mar 2006 13:22:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 31 Mar 2006 13:22:32 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: e56g2000cwe.googlegroups.com; posting-host=12.148.27.193;
   posting-account=NTrs9g0AAACt9-7FH-rZbzTVbWqZhLx-