DM8达梦数据库:DTS数据迁移工具异构数据库数据类型映射

环境介绍

• DMDTS 数据迁移工具 > 数据类型映射
  默认数据类型映射关系
  系统对应各迁移选项给出默认的数据类型映射关系。

1.ORACLE 到 DM

ORACLE	DM	注释
VARCHAR2	VARCHAR2
NVARCHAR2	NVARCHAR
NCHAR	CHAR
LONG	TEXT
RAW	VARBINARY
LONG RAW	LONGVARBINARY
NCLOB	CLOB
DATE	TIMESTAMP
INTERVALDS	INTERVAL DAY TO SECOND
INTERVALYM	INTERVAL YEAR TO MONTH
ROWID	BINARY
NROWID	VARBINARY
UROWID	VARBINARY
REF	LONGVARBINARY
STRUCT	LONGVARBINARY
ARRAY	LONGVARBINARY
STRUCT	LONGVARBINARY
ARRAY	LONGVARBINARY
AQ$_SUBSCRIBERS	LONGVARBINARY
BOOL	BIT
BOOLEAN	BIT
XMLTYPE	CLOB
SYS.XMLTYPE	CLOB
BINARY_FLOAT	FLOAT
BINARY_DOUBLE	DOUBLE
NUMBER	NUMBER	如果精度为126标度为-127,则映射为FLOAT;如果精度为63标度-127,则映射为REAL;否则映射为NUMBER

2.SYBASE 到 DM

SYBASE	DM	注释
NCHAR	CHAR
NCHARCHAR	VARCHAR
NTEXT	TEXT
TINYINT	SMALLINT
UNIQUEIDENTIFIER	VARCHAR
TIMESTAMP	VARBINARY
SMALLDATETIME	TIMESTAMP
DATETIME	TIMESTAMP
SMALLMONEY	NUMERIC
SQL_VARIANT	TEXT
MONEY	DECIMAL
BOOL	BIT
BOOLEAN	BIT
UNIVARCHAR	VARCHAR
UNICHAR	CHAR
UNSIGNED	BIGINT NUMBER
UNSIGNED INT	NUMBER
UNSIGNED SMALLINT	NUMBER
UNITEXT	TEXT

3.INFORMIX 到 DM

INFORMIX	DM	注释
BOOLEAN	BIT
INT8	NUMBER
LVARCHAR	VARCHAR
MONEY	NUMBER
NCHAR	CHAR
NVARCHAR	VARCHAR
SERIAL	INT
SERIAL8	NUMBER
SMALLFLOAT	FLOAT

4.SQLSERVER 到 DM

SQLSERVER	DM	注释
NCHAR	CHAR
NVARCHAR	VARCHAR
NTEXT	TEXT
TINYINT	SMALLINT
UNIQUEIDENTIFIER	VARCHAR
TIMESTAMP	BINARY
SMALLDATETIME	TIMESTAMP
DATETIME	TIMESTAMP
DATETIME2	TIMESTAMP
SMALLMONEY	NUMERIC
SQL_VARIANT	TEXT
MONEY	DECIMAL
MONEY	DECIMAL
BOOL	BIT
BOOLEAN	BIT
XML	TEXT
SYSNAME	VARCHAR
DATETIMEOFFSET	TIMESTAMP WITH TIME ZONE

5.postgreSQL 到 DM

postgreSQL	DM	注释
FLOAT4	FLOAT
FLOAT8	FLOAT
INT2	SMALLINT
INT4	INT
INT8	BIGINT
BPCHAR	CHAR
TIMETZ	TIME WITH TIME ZONE
TIMESTAMPTZ	TIMESTAMP WITH TIME ZONE
REGPROC	VARCHAR(100)
NAME	VARCHAR(100)
XID	INT
BOOL	BIT
BOOLEAN	BIT
BYTEA	BLOB
XML	TEXT
CHARACTER	VARYING VARCHAR
ABSTIME	TIMESTAMP WITH TIME ZONE
SERIAL	INT
BIGSERIAL	BIGINT
TSQUERY	TEXT
UUID	VARCHAR
CIRCLE	VARCHAR
POLYGON	TEXT
PATH	TEXT
BOX	VARCHAR
LSEG	VARCHAR
LINE	VARCHAR
POINT	VARCHAR
TSVECTOR	TEXT
BIT	BINARY
VARBIT	VARBINARY
MACADDR	VARCHAR
INET	VARCHAR
CIDR	VARCHAR
MONEY	NUMBER
INTERVAL类型	VARCHAR(100)

6.DB2 到 DM

DB2	DM	注释
DEC	DECIMAL
DBCLOB	CLOB
DBLINK	VARBINARY
ROWID	BINARY
GRAPHIC	CHAR
VARGRAPHIC	TEXT
DATALINK	VARBINARY
LONG VARCHAR FOR BIT DATA	VARBINARY
LONG VARCHAR	TEXT
VARCHAR () FOR BIT DATA	VARBINARY
CHAR () FOR BIT DATA	VARBINARY
LONG VARGRAPHIC	TEXT
XML	TEXT

7.Mysql 到 DM

Mysql	DM	注释
SET	CHAR
ENUM	CHAR
MEDIUMINT	INT
DATETIME	TIMESTAMP
YEAR	CHAR
MEDIUMBLOB	BLOB
LONGBLOB	BLOB
TINYBLOB	BLOB
TINYTEXT	CLOB
MEDIUMTEXT	CLOB
LONGTEXT	CLOB
LONGVARCHAR	CLOB
TINYINT UNSIGNED	INT
SMALLINT UNSIGNED	INT
MEDIUMINT UNSIGNED	INT
INT UNSIGNED	BIGINT
INTEGER UNSIGNED	BIGINT
BIGINT UNSIGNED	DECIMAL
BOOL	BIT
BOOLEAN	BIT

8.kingbase 到 DM

kingbase	DM	注释
FLOAT4	FLOAT
FLOAT8	FLOAT
INT2	SMALLINT
INT4	INT
BOOLEAN	BIGINT
BPCHAR	CHAR
BYTEA	IMAGE
BOOLEAN	BIT
XML	TEXT

9.ShenTong 到 DM

ShenTong	DM	注释
INT1	TINYINT
INT2	SMALLINT
INT4	INT
INT8	BIGINT
FLOAT4	REAL
FLOAT8	DOUBLE
BOOL	BIT
BOOLEAN	BIT
XML	CLOB