DataCompare tables list don't match

Compares and synchronizes SQL database content.

DataCompare tables list don't match

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

Postby Anu Deshpande » Mon Feb 10, 2014 10: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.
Anu Deshpande
Posts: 758
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests