How to synchronize my local Firebird database with another Firebird database?

Question

First of all, I read this question: Firebird Database Replication

But I do not want to replicate ... I just want to add data that has been changed in my database to our main database. Any ideas?

Answer 1

AFAICT that replication too.

Answer 2

You should note every change to your database and at the same time read them and transfer them to another database.

You can mark each entry with the logical value Modified = 0/1 or TimeStamp.

Through triggers you have to control these values

trigger before insert
begin
   modified = CurrentDateTime;
end

trigger before ubdate
begin
   modified = CurrentDateTime;
end

trigger before delete
begin
   insert into DELETED_RECORDS (id) values (old.id);
end