Database Migration v1 API - Class MappingRule (2.2.0)

public sealed class MappingRule : IMessage<MappingRule>, IEquatable<MappingRule>, IDeepCloneable<MappingRule>, IBufferMessage, IMessage

Reference documentation and code samples for the Database Migration v1 API class MappingRule.

Definition of a transformation that is to be applied to a group of entities in the source schema. Several such transformations can be applied to an entity sequentially to define the corresponding entity in the target schema.

Inheritance

object > MappingRule

Namespace

Google.Cloud.CloudDms.V1

Assembly

Google.Cloud.CloudDms.V1.dll

Constructors

MappingRule()

public MappingRule()

MappingRule(MappingRule)

public MappingRule(MappingRule other)
Parameter
NameDescription
otherMappingRule

Properties

ConditionalColumnSetValue

public ConditionalColumnSetValue ConditionalColumnSetValue { get; set; }

Optional. Rule to specify how the data contained in a column should be transformed (such as trimmed, rounded, etc) provided that the data meets certain criteria.

Property Value
TypeDescription
ConditionalColumnSetValue

ConvertRowidColumn

public ConvertRowIdToColumn ConvertRowidColumn { get; set; }

Optional. Rule to specify how multiple tables should be converted with an additional rowid column.

Property Value
TypeDescription
ConvertRowIdToColumn

DetailsCase

public MappingRule.DetailsOneofCase DetailsCase { get; }
Property Value
TypeDescription
MappingRuleDetailsOneofCase

DisplayName

public string DisplayName { get; set; }

Optional. A human readable name

Property Value
TypeDescription
string

EntityMove

public EntityMove EntityMove { get; set; }

Optional. Rule to specify how multiple entities should be relocated into a different schema.

Property Value
TypeDescription
EntityMove

Filter

public MappingRuleFilter Filter { get; set; }

Required. The rule filter

Property Value
TypeDescription
MappingRuleFilter

FilterTableColumns

public FilterTableColumns FilterTableColumns { get; set; }

Optional. Rule to specify the list of columns to include or exclude from a table.

Property Value
TypeDescription
FilterTableColumns

MappingRuleName

public MappingRuleName MappingRuleName { get; set; }

MappingRuleName-typed view over the Name resource name property.

Property Value
TypeDescription
MappingRuleName

MultiColumnDataTypeChange

public MultiColumnDatatypeChange MultiColumnDataTypeChange { get; set; }

Optional. Rule to specify how multiple columns should be converted to a different data type.

Property Value
TypeDescription
MultiColumnDatatypeChange

MultiEntityRename

public MultiEntityRename MultiEntityRename { get; set; }

Optional. Rule to specify how multiple entities should be renamed.

Property Value
TypeDescription
MultiEntityRename

Name

public string Name { get; set; }

Full name of the mapping rule resource, in the form of: projects/{project}/locations/{location}/conversionWorkspaces/{set}/mappingRule/{rule}.

Property Value
TypeDescription
string

RevisionCreateTime

public Timestamp RevisionCreateTime { get; set; }

Output only. The timestamp that the revision was created.

Property Value
TypeDescription
Timestamp

RevisionId

public string RevisionId { get; set; }

Output only. The revision ID of the mapping rule. A new revision is committed whenever the mapping rule is changed in any way. The format is an 8-character hexadecimal string.

Property Value
TypeDescription
string

RuleOrder

public long RuleOrder { get; set; }

Required. The order in which the rule is applied. Lower order rules are applied before higher value rules so they may end up being overridden.

Property Value
TypeDescription
long

RuleScope

public DatabaseEntityType RuleScope { get; set; }

Required. The rule scope

Property Value
TypeDescription
DatabaseEntityType

SetTablePrimaryKey

public SetTablePrimaryKey SetTablePrimaryKey { get; set; }

Optional. Rule to specify the primary key for a table

Property Value
TypeDescription
SetTablePrimaryKey

SingleColumnChange

public SingleColumnChange SingleColumnChange { get; set; }

Optional. Rule to specify how a single column is converted.

Property Value
TypeDescription
SingleColumnChange

SingleEntityRename

public SingleEntityRename SingleEntityRename { get; set; }

Optional. Rule to specify how a single entity should be renamed.

Property Value
TypeDescription
SingleEntityRename

SinglePackageChange

public SinglePackageChange SinglePackageChange { get; set; }

Optional. Rule to specify how a single package is converted.

Property Value
TypeDescription
SinglePackageChange

SourceSqlChange

public SourceSqlChange SourceSqlChange { get; set; }

Optional. Rule to change the sql code for an entity, for example, function, procedure.

Property Value
TypeDescription
SourceSqlChange

State

public MappingRule.Types.State State { get; set; }

Optional. The mapping rule state

Property Value
TypeDescription
MappingRuleTypesState