DataCompare tables list don't match

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

DataCompare tables list don't match

Postby jasv » Fri Feb 07, 2014 6:44 pm

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.
jasv
 
Posts: 1
Joined: Fri Feb 07, 2014 5:56 pm

Postby Anu Deshpande » Mon Feb 10, 2014 11:13 am

Thanks for your post jasv.

Can you check collation for both the databases? Is any one of them case sensitive?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
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