C
C
ChesterLife2012-06-03 06:23:22
SQLite
ChesterLife, 2012-06-03 06:23:22

Synchronization of SQLite databases

You need software that allows you to synchronize two SQLite databases. Target OS: Windows. Now I use the trial version of DatAdmin 5.4. The software is excellent and convenient, but you need a free analogue. I cannot manually compare two databases to find differences - it has about 3-3.5k lines scattered across tables.
Ready to listen to any ideas. It is quite possible that I did not notice some elephant under my nose and these databases can be synchronized somehow easier ...

Added:

Guys, thanks, but I beg your pardon ... the campaign I hinted at in vain about synchronization ...
The task is much more trivial: there is a database in English, I translate the text in it into Russian. After some time, a new version of this database is released, again in English with updated content. I need to find the differences between the old and the new database and transfer all the already translated data from the old database to the new one and continue translating the data already in the new database. Something like that.

Again, I apologize for asking the wrong question.

Added 2:

All here: docs.google.com/file/d/0B8YOnt3MiugydE5nQ1pveWRySE0/edit?pli=1

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
la0, 2012-06-03
@la0

Hello.
The solution is very simple: binlog emulation
CREATE TRIGGER update_t1 AFTER UPDATE ON t1
CREATE TRIGGER insert_t1 AFTER INSERT ON t1
CREATE TRIGGER delete_t1 DELETE ON t1
In triggers, log the change in any way.
Each table has its own triggers.
In the trigger, write a log to t1_log, where you simply collect the complete change request.
Good luck!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question