I am facing with the following issue:
I have two Databases, that have a table of the same form.
Database A, Table 1
Database B, Table 2 has the same columns.
I want to run the program every 1 minute and to compare all the values of the two databases, and i something does not exist in Database B to add it.
Do you know what is the most efficient way to do this?
I though of the following:
select all values from Database A
select the value from DB B to see if the record exists.
If it exists then move on to the following record.
If it does not exist then insert the record in Database B.
My way is a little time consuming.
All ideas are welcome