We have attempted this with a several different variations. We have not been able to make it work. Has anyone successfully synced data with a client by manually shipping logs?
Peter Haynes Pariveda Solutions 24 East Greenway Plaza | Suite 1717 | Houston, Texas 77046 (M) 713.408.8072 | (F) 713.520.4290 The Business of IT(r) www.parivedasolutions.com<http://www.parivedasolutions.com/> From: Bergquist, Brett [mailto:bbergqu...@canoga.com] Sent: Monday, February 17, 2014 1:41 PM To: Derby Discussion Subject: RE: data synchronization with no network What about using the database backup with roll-forward recovery? http://db.apache.org/derby/docs/10.10/adminguide/index.html I am not sure if this would work if one were to transfer a copy of the database to a slave and enable log archival mode and then periodically transport the archived logs to the slave and on the slave do a roll-forward recovery? From: not me [mailto:turbodo...@gmail.com] Sent: Sunday, February 16, 2014 6:20 PM To: derby-user@db.apache.org<mailto:derby-user@db.apache.org> Subject: data synchronization with no network We need to be able to push changes from a master database to several read-only slaves. In many situations, they have no network at all and move files around on memory sticks. They operate in remote locations where networks are impossible. They need to provided updates once a day to stakeholders who have a read-only copy of our application/database for reporting purposes. Derby replication pushes transaction logs from master to slave. Is it possible to copy transaction logs to the slave manually, and cause the target system to apply the changes to the slave? Ideally, we would want the following features. Is any of this available in Derby, or not to difficult to implement with custom code? 1. The target system will prevent import of data if a previous update file has not been applied 2. A user can can trigger the output of an update file (or trigger the system to package up for transport files that were written as changes were made), and the system will include all database changes since the previous update file was generated 3. A user can specify the range of changes to include, to allow inclusion of database changes a given slave may have missed Thanks in advance, and sorry if this is a duplicate question. I searched using several different key words and didn't find this topic.