I would like to know if there is a way to compare the data of tables in
different databases. For example I have table in db1 and exactly the
same table in db2. Is it possible to see if the contents of the two
tables are exactly the same?
For example if the table(db1.customer) has a column surname and the
field has a value of "Testing" and in db2.customer the exact same row
has a value "Testong" is it possible to actually know that there is a
difference ? I don't actually have to know what the actual differences
are , I must just know that there is a difference.
Thank you
Phillip