Hi,
today I have a theoretical question. I have red, that there is a
Database Replication Technology within Pervasive DataExchange, which can
synchronisze two (or more) PSQL-databases (including conflict-handling).

The question ist: if one has a pure btrieve-application (i.e. all changes to the
datatables are initiated by btrieve-calls (not SQL-update/change commands), but
if the btrieve-database itself is in the state, that it can used via SQL also
(i.e. all DDF-Files exist and are in well state):
in this case: can one use the "Database Replication Technology" für that
btrieve-database? The btrieve-application changes data via update and
add-operations: it does not use transactions. Is DataExchange aware of such
data-cahnges?


(The background is following: we want to have 2 identical btreive-databases: one
active and one passive on different servers (at sites A and B connected via
WAN). We want to synchronize them periodically (say all 10 mins). Changes take
place only in the active system (in A an B are active users, but usually they
use the System in A). But in case of WAN-fail, the passive system shoule hold
valid data not older than 10 mins. If the WAN remains down, in B one can use the
passive system to continue work, in A one can use the system in A.
If the WAN becomes valid later, one have to run a real Data-exchange to
resynchronize the systems.

The applications in A and B are breiteve-apps, but the databases can set
SQL-ready. Can one use the "Database Replication Technology within Pervasive
DataExchange" to do the synchs?)


as allways: any hint will be wellcome, thanks in advance.

regards
Mircea

Your analysis of the DataExchange is correct. The DataExchange
Real-Time Backup Edition will allow synchronization from one server to
a second server for fail-over capabilities. It can be scheduled on
whatever basis you wish, including every 10 minutes. (It can be as
frequent as continuously, though we usually recommend a 5-minute window
as the smallest time, and can even be used to replicate once per day if
you want that.)

The DX environment WILL capture changes made at the Btrieve level, and
then replicate them via SQL. In fact, no valid DDF's are required for
this edition, since it is doing one-way (Btrieve-level) replication.
For the Sync Edition, with two-way synchronization and changes being
made on BOTH sides, you WOULD need to have good DDF's.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2006 ***

nmm wrote:

Thank you Mr. Bach, these are good news. We will consider to use DX.
(We programmed a similiar function (incl. conflict-resolution-rules) ourself, it
works fine, but as a matter of principle only once a day. BTW our "alignment" is
in use since 1997)
Regards from Jena
Mircea

Bill Bach schrieb: