Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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.
- Posts: 1
- Joined: Fri Feb 07, 2014 5:56 pm
Thanks for your post jasv.
Can you check collation for both the databases? Is any one of them case sensitive?
- Posts: 692
- Joined: Mon Apr 20, 2009 3:53 pm
- Location: Cambridge
Return to SQL Data Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests