How to compare two tables
How to compare two tables, which are in different databases. Also, these databases are scheduled. One database table is already existing and functional the other database is newly developed. The new...
Forum Discussion
I think the easiest, and best way that is simple, is to use the diff snap. Unfortunately, I needed to know WHAT was changed, and have old data for the delets, so I had to emulate the diff snap through a join.
Our current scenario has tables in which there are composite keys and multiple columns are updated
