Database synchronization, how to do it?

Question

Database

There is a base on a remote server and a base on a computer. It is necessary to synchronize one table, not all data can be compared, but only some fields. The table is large, and I would like the process to be fast. Bases are different types.
How would you solve this problem?

Answer 1

Definitely don't transfer all the data every time. Add the "Revision" field to the data, which will increase each time the record in the table is updated, by the next global value.
When synchronizing, get from the database only those records whose revision is greater than the last one known to the remote server, and transfer only them.
Do they change the data in both databases, or does one of them uniquely own the data, while the second only reads?

Answer 2

select data from remote database -> put in local

Answer 3

Why nobody offers replication?