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:
- The table doesn't have a primary key, unique key, or unique constraint to do the comparison against
- 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:
Post a Comment