Subject Re: [Firebird-Java] Synchronize FB databases
Author Mark Rotteveel
On 12-12-2016 07:16, hugo.larson@... [Firebird-Java] wrote:
> I have a challenge and thought to post it here since maybe JayBird can
> help with a solution.
> What I want to do is to synchronize Firebird databases across the internet.
> The transmission of the synchronization data is out of the scope of the
> question. I will probably use webservice or websocket to send the data.
> I already have a mechanism for NBAK backups over the internet, which is
> not the solution since the data needs to be synchronized on the fly.
> I cannot install any replication software since our software is
> installed on many place and it would be a nightmare to maintain.
> Is it maybe possible for JayBird to create some kind of "delta" data
> with the changes which I pick up and send and execute on the remote
> database?

There is nothing in Jaybird for this, and of course such a solution
would not handle changes done outside of Jaybird.

I believe I have once seen a generic JDBC data source that could be used
for some form of replication, but I can't recall what it is called.

Mark Rotteveel