MSdbms_datatype_mapping (Transact-SQL)
The MSdbms_datatype_mapping table contains the allowable data type mappings from the data type in the source database management system (DBMS) to one or more specific data types in the destination DBMS. This table is stored in the msdb database and is used for heterogeneous database replication.
| Column name | Data type | Description |
|---|---|---|
datatype_mapping_id |
int |
Identifies each unique data type mapping. |
map_id |
int |
Identifies the source data type. |
dest_datatype_id |
int |
Identifies the destination data type. |
dest_precision |
bigint |
Defines the precision of the destination data type, where a value of NULL means that precision is not used, and a value of -1 means that the precision of the source data type is used. |
dest_scale |
int |
Defines the scale of the destination data type, where a value of NULL means that scale is not used, and a value of -1 means that the scale of the source data type is used. |
dest_length |
bigint |
Defines the length of the destination data type, where a value of NULL means that length is not used, and a value of -1 means that the length of the source data type is used. |
dest_nullable |
bit |
Indicates whether the destination column in the mapping allows NULL values, where a value of NULL means that this definition is not required. |
dest_createparams |
int |
The bitmap that describes what combination of length, precision, and scale are applicable for each data type, which includes: 0x1 = PRECISION. 0x2 = SCALE. 0x4 = LENGTH. |
See Also
Reference
Replication Views (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
Other Resources
Heterogeneous Database Replication
How to: Specify Data Type Mappings for an Oracle Publisher (Replication Transact-SQL Programming)