|
 This page controls the
way named objects are associated with each other during the schema
comparison.
Case
sensitivity. The default and the
most reasonable setting for the case-sensitivity is
Automatic.
Although SQL is usually considered a case-insensitive language, for
MS SQL this depends on the collation order specified for the
database when it was created (and, therefore, for the system tables
containing object names). With the Automatic
setting, the
Diff runs case-sensitive name comparison only if
both databases use case-sensitive
collations for object names.
Comparing
and mapping owner/schema names. This option group
allows to handle situations when equivalent objects in the two
databases have different owner names (or schema names in
SQL2005/2008). This way, for example, table DBO.Employees on your
development server may be compared to Joe.Employees on the
production server. You can choose to either ignore schema names
completely or (recommended) to specify mappings between the owner
names ("dbo=Joe", in this example). The mappings can be added in a
pop-up dialog which appears when you click on the [Edit
mappings...] button.
Note
that this
option and the owner mapping table are kept with the current
comparison project, not with the global
options. To save them, you must save the project.
|
