SQL Data Compare 11

Data that wasn't deployed

When you deploy the data sources, some rows may not be deployed if:

  • there are triggers defined on the tables

    If you have a trigger defined on a table that inserts data into another table on INSERT, DELETE, or UPDATE, the data in the tables will change as the deployment is run, which will cause unpredictable results. To avoid this, select the Disable DML triggers project option before you generate the deployment script.

  • primary keys are defined on columns with differing collations

    If you compare tables that have primary keys defined on columns that have different collations, SQL Data Compare may produce unpredictable results.

  • columns contain timestamp data

    SQL Data Compare can't deploy data in timestamp columns.

  • table structures are not identical

    If the structure of the tables you're deploying is not identical, SQL Data Compare may produce unpredictable results.

CLR data that wasn't deployed

Data for CLR types can be stored as string or binary values. When CLR data is compared, SQL Data Compare always compares the binary representations. However, by default, when CLR data is deployed, SQL Data Compare deploys the string representations, because binary formats are not always compatible.

If the binary representations are not compatible, they are always displayed as different even if the string representations are identical. String representations do not always contain the full information about the data, so when the databases are re-compared using the binary representations following deployment, they may be displayed as different.

If you know that the binary formats are compatible, you can select the project configuration option Transport CLR data types as binary.

This forces SQL Data Compare to deploy the binary representations.

Primary keys, indexes, or unique constraints that weren't dropped for deployment

If you select the project configuration option Drop primary keys, indexes, and unique constraints, note that primary keys, indexes or unique constraints that are selected as comparison keys are not dropped for the deployment.


Didn't find what you were looking for?