How can we help you today? How can we help you today?

Error when calling ComparisonSession.CompareDatabases

When I call ComparisonSession.CompareDatabases while comparing two database backups, I get the following error:

"No matching index was found for table Employee_Fingerprint"

Do all the tables have to have an index for SDC to compare them? How can I prevent this error?

Thanks.
RBohannon
0

Comments

1 comment

Sort by
  • Robert C
    Hi,

    When comparing backups, yes, you need to have some kind of index on the tables in order to compare them. This can be clustered or non-clustered, with clustered indexes generally giving superior performance (as you'd expect in SQL Server itself).

    Hope that helps,
    Robert
    Robert C
    0

Add comment

Please sign in to leave a comment.