SQLServer源端映射到神通目的端

源数据类型	精度	小数位	长度	目的数据类型（默认）	精度	小数位	长度倍数	目的数据类型（可选）
CHAR				CHAR				VARCHAR|TEXT|CLOB
VARCHAR				VARCHAR				CHAR|TEXT|CLOB
VARCHAR			L=-1	CLOB				VARCHAR|CHAR|TEXT
NCHAR				CHAR				VARCHAR|TEXT|CLOB
NVARCHAR				VARCHAR				CHAR|TEXT|CLOB
NVARCHAR			L=-1	CLOB				VARCHAR|CHAR|TEXT
TEXT				CLOB				VARCHAR|CHAR|TEXT
NTEXT				CLOB				VARCHAR|CHAR|TEXT
BIGINT				INT8				DECIMAL|NUMERIC|TINYINT|SMALLINT|INT|BIGINT|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
INT				INT4				INT8|DECIMAL|NUMERIC|TINYINT|SMALLINT|INT|BIGINT|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
SMALLINT				INT2				INT8|DECIMAL|NUMERIC|TINYINT|SMALLINT|INT|BIGINT|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
TINYINT				SMALLINT	3	0		DECIMAL|NUMERIC|TINYINT|INT2|INT|BIGINT|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
MONEY				NUMERIC	19	4		DECIMAL|TINYINT|INT|SMALLINT|INT2|BIGINT|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
SMALLMONEY				NUMERIC	10	4		DECIMAL|TINYINT|INT|SMALLINT|INT2|BIGINT|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
DECIMAL	P<=15	S!=0		FLOAT8				TINYINT|INT|SMALLINT|BIGINT|DECIMAL|NUMERIC|NUMBER|FLOAT|FLOAT4|DOUBLE PRECISION
DECIMAL	P<=2	S=0		SMALLINT				TINYINT|INT|INT1|BIGINT|DECIMAL|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
DECIMAL	2<P<=4	S=0		INT2				TINYINT|INT|SMALLINT|BIGINT|DECIMAL|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
DECIMAL	4<P<=9	S=0		INT4				TINYINT|INT|SMALLINT|BIGINT|DECIMAL|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
DECIMAL	9<P<=18	S=0		INT8				TINYINT|INT|SMALLINT|BIGINT|DECIMAL|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
DECIMAL	P=P	S=0		DECIMAL	P	S		TINYINT|INT1|INT|SMALLINT|INT2|INT4|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
NUMERIC	P<=15	S!=0		FLOAT8				TINYINT|INT1|INT|SMALLINT|INT2|INT4|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|DECIMAL|DOUBLE PRECISION
NUMERIC	P<=2	S=0		SMALLINT				TINYINT|INT|INT1|INT2|INT4|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DECIMAL|DOUBLE PRECISION
NUMERIC	2<P<=4	S=0		INT2				TINYINT|INT|SMALLINT|INT1|INT4|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DECIMAL|DOUBLE PRECISION
NUMERIC	4<P<=9	S=0		INT4				TINYINT|INT|SMALLINT|INT1|INT2|INT8|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DECIMAL|DOUBLE PRECISION
NUMERIC	9<P<=18	S=0		INT8				TINYINT|INT|SMALLINT|INT1|INT2|INT4|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DECIMAL|DOUBLE PRECISION
NUMERIC	P=P	S=S		DECIMAL	P	S		TINYINT|INT|SMALLINT|INT1|INT2|INT4|INT8|BIGINT|NUMERIC|NUMBER|FLOAT|FLOAT4|FLOAT8|DOUBLE PRECISION
FLOAT	25<=P<=53			FLOAT8
FLOAT	1<=P<=24			FLOAT4				FLOAT|TINYINT|INT1|INT2|INT4|INT8|INT|SMALLINT|BIGINT|DECIMAL|NUMERIC|NUMBER|DOUBLE PRECISION
REAL				FLOAT4				FLOAT|TINYINT|INT1|INT2|INT4|INT8|INT|SMALLINT|BIGINT|DECIMAL|NUMERIC|NUMBER|DOUBLE PRECISION
BIT	25<=P<=53			BIT			L+1
IMAGE				BLOB
BINARY				BINARY				BLOB
VARBINARY				VARBINARY				BLOB
VARBINARY			L=-1	BLOB
DATETIME				TIMESTAMP	3
DATE				DATE
DATETIME2				TIMESTAMP	6
SMALLDATETIME				TIMESTAMP	0
UNIQUEIDENTIFIER				VARCHAR			L=36
TIMESTAMP				BINARY			L=8
SQL_VARIANT				VARCHAR			L=8000
SYSNAME				VARCHAR	256
XML				XML				CLOB