I have 2 databases where one is a restored back up of the other from a few days ago. When I run the datacompare and look at the "Tables & Views" tab none of the tables match even though all the names are identical.
The list comes up with the left column table names with no matching table names on the right. If I page down, then the right side table names are shown with no matching left table names.
I tried restoring the db again but the same result. I can query and access the restored table without any issues.
Any suggestions/advice would be appreciated.