Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Real-Time Jobs)/ Field Type Mapping/ Mapping Between SQL Server and Doris Field Types
Updated on 2026-09-14 GMT+08:00
View PDF
Share

Mapping Between SQL Server and Doris 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 Doris.

Table 1 Field types supported by a job that migrates data from SQL Server to Doris

Type

SQL Server Data Type

Doris Data Type

Description

String

BINARY

TEXT

-

VARBINARY

TEXT

-

CHAR(M)

CHAR(3M)

-

VARCHAR(M)

VARCHAR(3M)

-

NCHAR(M)

VARCHAR(3M)

-

NVARCHAR(M)

VARCHAR(3M)

-

NTEXT

TEXT

-

TEXT

TEXT

-

IMAGE

TEXT

-

XML

TEXT

-

Numeric

DECIMAL

DECIMAL

-

NUMERIC

DECIMAL

-

FLOAT

DOUBLE

-

REAL

FLOAT

-

INT

INT

-

BIGINT

BIGINT

-

SMALLINT

SMALLINT

-

TINYINT

SMALLINT

-

MONEY

DECIMAL(19,4)

-

SMALLMONEY

DECIMAL(10,4)

-

Bit

BIT

BOOLEAN

-

Date and time

DATE

DATE

-

TIME

TEXT

-

DATETIME

DATETIME(3)

-

DATETIME2

TEXT

-

SMALLDATETIME

DATETIME

-

DATETIMEOFFSET

TEXT

-
Parent topic: Field Type Mapping