Data Type Conversion Reference
This page outlines examples that show the result of converting the source value and data type to a specific BSON data type using customized fields.
Behavior
Migration job errors result in
BsonNullvalues for the impacted fields. Your field's null handling strategy does not affect this behavior.Your migration job continues with errors unless it reaches the threshold that you defined when you created the migration job.
When defining Calculated Fields and Customize ID Fields, Relational Migrator shows an initial data type of default. When you run a migration job, Relational Migrator updates this data type.
Integer
The following example shows results from applying data type
customization for the value 100 with an Integer data type.
Conversion Type | Conversion Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Boolean
The following example shows results from applying data type
customization for the value true with a Boolean data type.
Conversion Type | Conversion Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long
The following example shows results from applying data type
customization for the value 1233140483647 with a Long data type.
Conversion Type | Conversion Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Decimal
The following example shows results from applying data type
customization for the value 26.55 with a Decimal data type.
Conversion Type | Conversion Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
String
The following example shows results from applying data type
customization for the value "Hello" with a String data type.
Conversion Type | Conversion Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The following example shows results from applying data type
customization for the value "true" with a String data type.
Conversion Type | Conversion Value |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|