Options used when generating the mapping between two databases.
Namespace:
RedGate.SQLDataCompare.EngineAssembly: 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 name | Description | |
---|---|---|
Default | The default options when generating the mappings. These are:
| |
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.
|