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)

Help and Information

Getting SQL Server 2005 Assistance