SQL Compare 13

SQL Compare shows identical objects as different

SQL Compare sometimes shows information that appears to be inconsistent regarding the top half of the screen (the results pane) and the bottom half (the SQL diff view).

Objects are listed as "Different" in the results pane but the SQL looks the same.

For example, select one of the views and see (view =/= view) at the top but the details do not show any lines of the view that are different.  

The issue is a textual vs semantic comparison issue but there can be several causes, such as unusual whitespace characters in text objects.

To investigate this situation further, it is often useful to look at the deployment script for the object, which can be accessed by right-clicking on the object in the results pane.  

The object is listed in the "identical" group in the top grid, but when you click on the object it is shown with differences in the bottom grid

The difference is probably related to the two types of comparison SQL Compare performs.  When SQL Compare compares a schema, a semantic comparison will be performed (top grid) which will group the objects based on the rules you have applied to the deployment and other basic functionally similar syntax that will automatically be ignored. It is these differences that will be deployed.

The other comparison is a straight textual comparison, that will be displayed in the bottom SQL Differences pane. All textual differences will be highlighted here. We can try match the rows as best we can, but each method will have its limitations and we don't think it would be right to reorder the SQL at this stage.

For example, if you are using mappings, the object names may be different; if you are ignoring column order this may be different etc., but the semantic comparison will determine that the objects are identical.


Didn't find what you were looking for?