Compare Parameters

Before comparing the data source with the *.dbd (for example, MmsData.dbd), set the parameters DBEdit should use when doing the comparison.

Table 1. Description of Compare Parameters
Parameter Description
Objects missing in DS This applies to entire tables only and not to columns.

Missing columns are not affected by this option.

This is selected by default.

Objects missing in DBD

If selected, then any table that is in the data source but not in the *.dbd file is shown as a difference.

This applies to entire tables only and not to columns.

Missing columns are not affected by this option.

This is selected by default.

Skip Index Compare This excludes the indexes during the compare process.
Ignore Var vs Fixed, Var, Long This indicates that the compare process does not consider two text fields different if their only difference is that one is variable length and the other is fixed length provided that the maximum length of the variable field is the same as the length of the fixed field.
Ignore Long Var Extra The compare process does not consider differences in the maximum length of long varchar (various characters) text fields.

Long varchar text fields are variable length text fields with lengths greater than 254 characters.

This is selected by default.

Check duplicate tables The system checks for duplicate tables.

This is selected by default.