Options used when generating the mapping between two databases.

Namespace:  RedGate.SQLDataCompare.Engine
Assembly:  RedGate.SQLDataCompare.Engine (in RedGate.SQLDataCompare.Engine.dll)

Syntax

Visual Basic (Declaration)
<FlagsAttribute> _
Public Enumeration MappingOptions
C#
[FlagsAttribute]
public enum MappingOptions
Visual C++
[FlagsAttribute]
public enum class MappingOptions

Members

Member nameDescription
Default

The default options when generating the mappings. These are:

  • IgnoreCase
  • IgnoreSpaces
  • IncludeIdentities
  • IncludeTimestamps
None
None.
IgnoreCase
Ignores the case of the object names (tables, views, users, roles, schemas, indexes, and columns) when mapping. For example, [dbo].[Widget] is considered to be the same as [dbo].[widget] when you select this option.
IgnoreSpaces
Ignores the spaces in the object names (tables, views, users, roles, schemas, indexes, and columns) when mapping. For example, [dbo].[Widget Prices] is considered to be the same as [dbo].[WidgetPrices] when you select this option.
IgnoreUnderscores
Ignores the underscores in the object names (tables, views, users, roles, schemas, indexes, and columns) when mapping. For example, [dbo].[Widget_Prices] is considered to be the same as [dbo].[WidgetPrices] when you select this option.
MissingFrom2AsInclude
When the object does not exist in the second database, the Mapping status is set to success and include is set to true.
IncludeTimestamps
Includes timestamp columns from the tables or views in the schema information for the database. Timestamp columns cannot be synchronized.
IncludeIndexedViews
Includes views in the schema information for the database. Views can be synchronized only if the referenced rows are from a single table, and the referenced columns are simple (for example, they must not include identity columns or computed columns).
IncludeIdentities
Includes identity columns from the tables or views in the schema information for the database. You cannot synchronize views if they include an identity column.

See Also