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
Implements
Inherited Members
Namespace: Google.Apis.DatabaseMigrationService.v1.Data
Assembly: Google.Apis.DatabaseMigrationService.v1.dll
Syntax
public class MappingRule : IDirectResponseSchema

Properties

ConditionalColumnSetValue

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.

Declaration
[JsonProperty("conditionalColumnSetValue")]
public virtual ConditionalColumnSetValue ConditionalColumnSetValue { get; set; }
Property Value
Type Description
ConditionalColumnSetValue

ConvertRowidColumn

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

Declaration
[JsonProperty("convertRowidColumn")]
public virtual ConvertRowIdToColumn ConvertRowidColumn { get; set; }
Property Value
Type Description
ConvertRowIdToColumn

DisplayName

Optional. A human readable name

Declaration
[JsonProperty("displayName")]
public virtual string DisplayName { get; set; }
Property Value
Type Description
string

ETag

The ETag of the item.

Declaration
public virtual string ETag { get; set; }
Property Value
Type Description
string

EntityMove

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

Declaration
[JsonProperty("entityMove")]
public virtual EntityMove EntityMove { get; set; }
Property Value
Type Description
EntityMove

Filter

Required. The rule filter

Declaration
[JsonProperty("filter")]
public virtual MappingRuleFilter Filter { get; set; }
Property Value
Type Description
MappingRuleFilter

FilterTableColumns

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

Declaration
[JsonProperty("filterTableColumns")]
public virtual FilterTableColumns FilterTableColumns { get; set; }
Property Value
Type Description
FilterTableColumns

MultiColumnDataTypeChange

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

Declaration
[JsonProperty("multiColumnDataTypeChange")]
public virtual MultiColumnDatatypeChange MultiColumnDataTypeChange { get; set; }
Property Value
Type Description
MultiColumnDatatypeChange

MultiEntityRename

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

Declaration
[JsonProperty("multiEntityRename")]
public virtual MultiEntityRename MultiEntityRename { get; set; }
Property Value
Type Description
MultiEntityRename

Name

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

Declaration
[JsonProperty("name")]
public virtual string Name { get; set; }
Property Value
Type Description
string

RevisionCreateTime

object representation of RevisionCreateTimeRaw.

Declaration
[JsonIgnore]
[Obsolete("This property is obsolete and may behave unexpectedly; please use RevisionCreateTimeDateTimeOffset instead.")]
public virtual object RevisionCreateTime { get; set; }
Property Value
Type Description
object

RevisionCreateTimeDateTimeOffset

DateTimeOffset representation of RevisionCreateTimeRaw.

Declaration
[JsonIgnore]
public virtual DateTimeOffset? RevisionCreateTimeDateTimeOffset { get; set; }
Property Value
Type Description
DateTimeOffset?

RevisionCreateTimeRaw

Output only. The timestamp that the revision was created.

Declaration
[JsonProperty("revisionCreateTime")]
public virtual string RevisionCreateTimeRaw { get; set; }
Property Value
Type Description
string

RevisionId

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.

Declaration
[JsonProperty("revisionId")]
public virtual string RevisionId { get; set; }
Property Value
Type Description
string

RuleOrder

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.

Declaration
[JsonProperty("ruleOrder")]
public virtual long? RuleOrder { get; set; }
Property Value
Type Description
long?

RuleScope

Required. The rule scope

Declaration
[JsonProperty("ruleScope")]
public virtual string RuleScope { get; set; }
Property Value
Type Description
string

SetTablePrimaryKey

Optional. Rule to specify the primary key for a table

Declaration
[JsonProperty("setTablePrimaryKey")]
public virtual SetTablePrimaryKey SetTablePrimaryKey { get; set; }
Property Value
Type Description
SetTablePrimaryKey

SingleColumnChange

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

Declaration
[JsonProperty("singleColumnChange")]
public virtual SingleColumnChange SingleColumnChange { get; set; }
Property Value
Type Description
SingleColumnChange

SingleEntityRename

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

Declaration
[JsonProperty("singleEntityRename")]
public virtual SingleEntityRename SingleEntityRename { get; set; }
Property Value
Type Description
SingleEntityRename

SinglePackageChange

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

Declaration
[JsonProperty("singlePackageChange")]
public virtual SinglePackageChange SinglePackageChange { get; set; }
Property Value
Type Description
SinglePackageChange

SourceSqlChange

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

Declaration
[JsonProperty("sourceSqlChange")]
public virtual SourceSqlChange SourceSqlChange { get; set; }
Property Value
Type Description
SourceSqlChange

State

Optional. The mapping rule state

Declaration
[JsonProperty("state")]
public virtual string State { get; set; }
Property Value
Type Description
string

Implements