Page History
...
- Idera SQL Schema Compare index comparison options may “hide” differences between two different indexes and make them appear equal. Currently, IDERA Idera SQL Schema Compare supports seven index options available by clicking Comparison Options > Index Options. If an option is unchecked, the property affected by it is not compared.
- When check constraints have the same name on different tables, they may not be identified as different when using IDERA Idera SQL Schema Compare. For example, the check constraints would look as follows:
LOC_TX.g_1835_ck
LOC_CA.g_1835_ck
Note the following operation of IDERA Idera SQL Schema Compare:- SQL Server supports two types of check constraints: column-constraints and table-constraints. A column constraint is applied to one column only while a table constraint affects multiple columns.
- Table-constraints have a table-scope, i.e. the constraints on the left database are compared with constraints of the same table on the right database.
- Column constraints have a table and column scope, so constraints on the left database are compared with the constraints of the same table, under the same column, on the right database.
LOC_TX
table on the left database are compared with those of theLOC_TX
table on the right database. Constraints ofLOC_TX
andLOC_CA
are not mixed together.
IDERA Idera SQL Schema Compare can ignore the name of a check constraint if the option Ignore check constraint name is checked. This option affects only column constraints and it is located under Comparison Options > Constraint Options.
...
Some users may see an error occurring during object pairing before the schema comparison. This issue usually results from a database created with case-sensitive collation and containing objects with the same name but different case, such as Employee and employee. Note that while this error is triggered, IDERA Idera SQL Schema Compare does continue to compare the databases. However, from the set of objects with the same name, only one of them is compared and the remainder is ignored.
...