I have 2 databases, one is like a backup for the other.
So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK
I want to compare those two tables and copy only new entries (rows) to the backup database.
How can I do that? Can it be done like a stored procedure?
Thank`s in advance for the help.
Have a nice day,