Tuesday, February 26, 2008

Data Compare Does Not List All Tables

VSTS for Database Professionals has a great tools like schema and data compare. I got a lot of questions why schema compare list all tables in the target and source databases, but data compare not.

So, the answer is simple. There are 2 possible reasons to this issue:

  1. The table doesn't have a primary key, unique key, or unique constraint to do the comparison against
  2. The table definitions are different

VSTS for Database Professionals uses a key or index to determine which objects correspond with each other when we use the data compare. If a table or view in the source database has more than one primary key, unique index, or unique constraint that matches that of a table or view in the target database, we can specify which one to use for the comparison on the second page of the New Data Comparison wizard.

No comments: