I do have a requirement to find if there is any difference between 2 tables in different databases. Both these tables reside in two different databases. All the columns in Table 2 are present in Table 1, but Table 1 will have more columns comparitively to Table 2.
Some rows in Table 1 will be updated daily. I need to find out if these updates in Table 1 are related to Table 2 columns.
Any help is appreciated.