Page History
IDERA Idera strives to ensure our products provide quality solutions for your SQL Server needs. The following known issues are described in this section. If you need further assistance with any issue , please contact IDERA Idera Support.
Known issues
Two different databases appear equal to some users
IDERA Idera SQL Comparison Toolset includes a number of options that can cause the following issues:
- IDERA Idera SQL Schema Compare index comparison options may “hide” differences between two different indexes and make them appear equal. Currently, 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 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 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 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.
...