Mapping Between SQL Server and GaussDB(DWS) Field Types

DataArts Migration converts the source field type to the destination field type based on the default rule, and creates tables and synchronizes data in real time.

Field Type Mapping Rules

The following table lists the field types supported by a job that migrates data from SQL Server to GaussDB(DWS).

**Table 1** Field types supported by a job that migrates data from SQL Server to GaussDB(DWS)
Type	SQL Server Data Type	GaussDB(DWS) Data Type	Description
String	BINARY	BYTEA	N/A
	VARBINARY	BYTEA	N/A
	CHAR	CHAR	N/A
	VARCHAR	VARCHAR	N/A
	NCHAR	VARCHAR	N/A
	NVARCHAR	VARCHAR	N/A
	NTEXT	TEXT	N/A
	TEXT	TEXT	N/A
	IMAGE	BYTEA	N/A
	XML	TEXT	N/A
Value	DECIMAL	NUMERIC	N/A
	NUMERIC	NUMERIC	N/A
	FLOAT	FLOAT8	N/A
	REAL	FLOAT8	N/A
	INT	INTEGER	N/A
	BIGINT	BIGINT	N/A
	SMALLINT	SMALLINT	N/A
	TINYINT	SMALLINT	N/A
	MONEY	NUMERIC(19,4)	N/A
	SMALLMONEY	NUMERIC(10,4)	N/A
Bit	BIT	BOOLEAN	N/A
Date and time	DATE	DATE	N/A
	TIME	TIME	N/A
	DATETIME	TIMESTAMP(6)	N/A
	DATETIME2	TIMESTAMP(6)	N/A
	SMALLDATETIME	TIMESTAMP(6)	N/A
	DATETIMEOFFSET	TIMESTAMPZ(6)	N/A