Comparing 2 Tables in different Databases

[Andrew Gable]

Hi Everyone,

Happy New Year to you all.

I would like some advice on the following matter

I have 2 databases Database A is running on my Local PC and Database B is running on my Main network server

I am using a Small Program to keep the two databases in sync

It is possible to get from the Main Database ONLY records that have changes / does not exist in the Local Database?

I am NOT using replication as that looks way to hard to set up and maintain

So My Appliation is written in Gambas3 (for Linux) and it connects to both my Network Database and local Database and moves data between them

is there a SQL Command I can use to only return changed data (example Item 10101 price was Changed on the Server database is there way i can use SQL to compare what is in the local database to what is stored on the server)