DM8达梦数据库:DTS数据迁移工具异构数据库数据类型映射
DM 数据迁移工具 > 数据类型映射
默认数据类型映射关系
系统对应各迁移选项给出默认的数据类型映射关系。
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 | |
最后
以上就是昏睡树叶最近收集整理的关于DM8达梦数据库:DTS数据迁移工具异构数据库数据类型映射的全部内容，更多相关DM8达梦数据库内容请搜索靠谱客的其他文章。
本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。
发表评论 取消回复