Microsoft SQL Server->GaussDB

TINYINT

SMALLINT

Yes

SMALLINT

SMALLINT

Yes

INT

INTEGER

Yes

BIGINT

BIGINT

Yes

DECIMAL

NUMERIC

Yes

NUMERIC

NUMERIC

Yes

FLOAT

DOUBLE PRECISION

Yes

REAL

REAL

Yes. The precision of SQL Server is 7 digits, while that of GaussDB is 6 digits. If the REAL value of the source database has 7 digits, 1-digit precision loss will occur when the value is synchronized to the destination database.

SMALLMONEY

NUMERIC(10,4)

Yes

MONEY

NUMERIC(19,4)

Yes

BIT

BOOLEAN

Yes

DATE

DATE

Yes

SMALLDATETIME

SMALLDATETIME

Yes

DATETIME

TIMESTAMP(3) WITHOUT TIME ZONE

Yes

DATETIME2

TIMESTAMP WITHOUT TIME ZONE

Yes

DATETIMEOFFSET

TIMESTAMP WITH TIME ZONE

Yes

TIME(p)

TIME(P) WITHOUT TIME ZONE

The value can be accurate to seconds. Decimals are discarded.

TIMESTAMP

BYTEA

Yes

XML

CLOB

Yes

CHAR

CHARACTER

Yes. If a column of this type in the source database contains characters that occupy more than one byte, increase the length of the column in the destination database.

VARCHAR

CHARACTER VARYING()

Supported

VARCHAR(max)

CLOB

Supported

NCHAR

CHARACTER VARYING()

Supported

NVARCHAR

NVARCHAR2

Yes. If a column of this type in the source database contains characters that occupy more than one byte, increase the length of the column in the destination database.

NVARCHAR(max)

CLOB

Yes

BINARY

BYTEA

Yes

VARBINARY

BYTEA

Yes

VARBINARY(max)

BLOB

Yes

IMAGE

BLOB

Yes

HIERARCHYID

BYTEA

Yes

NTEXT

CLOB

Yes

TEXT

CLOB

Yes

UNIQUEIDENTIFIER

CHARACTER(36)

Yes