MSdbms_map (Transact-SQL)
The MSdbms_map table contains source data type information as well as a link to default destination data type information for source and destination DBMS pairs. This table is stored in the msdb database and is used for heterogeneous publishing.
| Column name | Data type | Description |
|---|---|---|
map_id |
int |
Uniquely identifies a data type mapping. |
src_dbms_id |
int |
Identifies the source DBMS by specifying its dbms_id in the MSdbms table. |
dest_dbms_id |
int |
Identifies the destination DBMS by specifying its dbms_id in the MSdbms table. |
src_datatype_id |
int |
Identifies the datatype_id from the MSdbms_datatype table for the source data type. |
src_len_min |
bigint |
The minimum length of the data type at the source DBMS, where a value of NULL indicates that length is not used. |
src_len_max |
bigint |
The maximum length of the data type at the source DBMS, where a value of NULL indicates that length is not used. |
src_prec_min |
bigint |
The minimum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used. |
src_prec_max |
bigint |
The maximum precision of the data type at the source DBMS, where a value of NULL indicates that precision is not used. |
src_scale_min |
int |
The minimum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used. |
src_scale_max |
int |
The maximum scale of the data type at the source DBMS, where a value of NULL indicates that scale is not used. |
src_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. |
default_datatype_mapping_id |
int |
Identifies the default data type mapping by specifying its map_id in table MSdbms_datatype_mapping. |
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)