MSdatatype_mappings (Transact-SQL)
The MSdatatype_mappings view maps SQL Server data types to data types used by non-SQL Server database management systems (DBMS). This table is stored in the msdb database.
Column name
Data type
Description
dbms_name
nvarchar(128)
Is the name of the DBMS, and can be one of the following values:
Value
Description
MSSQLSERVERThe destination is a SQL Server database.
ORACLEThe destination is an Oracle database.
DB2The destination is an IBM DB2 database.
SYBASEThe destination is a Sybase database.
sql_type
nvarchar(128)
Is the SQL Server data type.
dest_type
nvarchar(128)
Is the name of the non-SQL Server data type.
dest_prec
bigint
Is the precision of the non-SQL Server data type.
dest_create_params
int
Internal use only.
dest_nullable
bit
Is if the non-SQL Server data type supports a NULL value.
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)