SQL Server Datatype Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

SQL Server Datatype Mapping

  • Dark
    Light
  • PDF

Article summary

While extracting your data, we match SQL Server data types to Rivery data types. If a data type isn't supported, we will automatically map it as a String type.

The mapping of SQL Server data types to Rivery-compatible types is shown in the table below:

SQL Server TypeRivery Type
REAL
FLOAT
SMALLDATETIME
TIMESTAMP
CLOB
STRING
TEXT
STRING
CHAR
STRING
TINYINT
INTEGER
BIGINT
INTEGER
DATETIME2
TIMESTAMP
DATE
DATE
TEXTSTRING
VARBINARY
STRING
NUMERIC
FLOAT
BIT
BOOLEAN
JSON
STRING
IMAGE
STRING
INTEGER
INTEGER
ARRAY
STRING
NTEXT
STRING
SMALLMONEY
STRING
DECIMAL
FLOAT
DATETIME
TIMESTAMP
MONEY
STRING
BINARY
STRING
UNIQUEIDENTIFIER
STRING
TIMESTAMP
STRING
FLOAT
FLOAT
BOOLEAN
BOOLEAN
BLOB
STRING
TIME
STRING
DATETIMEOFFSET
STRING
XMLSTRING

Please Note: 

The GEOGRAPHYHIERARCHYID and IMAGE datatypes are not supported.


Was this article helpful?

What's Next