MySQL Forums
Forum List  »  Newbie

Comparing 2 Tables in different Databases
Posted by: Andrew Gable
Date: January 01, 2022 05:59PM

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)

Options: ReplyQuote


Subject
Written By
Posted
Comparing 2 Tables in different Databases
January 01, 2022 05:59PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.