Comparing Data b/w 2 database (environment)
Hi .. I was wondering if there's a way to compare the data that reside in the same table names but in 2 different databases. Basically. I have 2 databses (one test and one production). The test db was refreshed so that it mirrors the production data but when I executed the same queriy in these 2 separate dbases, I got diffrent results. So I want to know what makes up the difference. I can execute the query 2 separate times and export the result to Excel but my expected count is way more than what Excel can hold. Is it possible then to write a query involving these 2 dbs? Thanks.
I