I have two locations with two databases. The two locations are not connected to the internet all the time. So we have a log of all transactions saved as SQL statements inside a table.
I want to have a way to connect the two computers via the internet and update them with the new SQL statements. One of the two locations, the Server, will have a fixed IP address or URL. The other one should connect to the server on a regular basis to send and receive the updates.
I have attached a sample db file. The ReplaySQL table has sample sql statements to be executed on the other computer.
Please use the following technologies:
Delphi 10.3 Community Edition, Firebird 2.5, Interbase Express components if needed.