SQL Server Data Types Transformation Mapping
  • 1 Minute to read
  • Dark
    Light
  • PDF

SQL Server Data Types Transformation Mapping

  • Dark
    Light
  • PDF

As Rivery maps and extracts tables in SQL Server, the system makes mapping between the data type in the source, the supported data type in Rivery, and the target's data type. 

In cases data types are not supported by the target, Rivery will convert the type to the closest known matched, or ignore the field and load it as NULL data with the equivalent data type. 

Here are the supported data types from SQL Server in Rivery.


Source Data TypeRivery Target Data TypeSupported?
REALFLOATv
DATETIMEOFFSETTIMESTAMPx
SMALLDATETIMETIMESTAMPv
CLOBSTRINGx
TEXTSTRINGv
CHARSTRINGv
TINYINTINTEGERv
BIGINTINTEGERv
DATETIME2TIMESTAMPv
DATEDATEv
VARBINARYSTRINGv
SMALLINTINTEGERv
VARCHARSTRINGv
NUMERICFLOATv
BITBOOLEANv
JSONSTRINGv
IMAGESTRINGx
INTEGERINTEGERv
ARRAYSTRINGv
NTEXTSTRINGv
SMALLMONEYSTRINGv
DECIMALFLOATv
DATETIMETIMESTAMPv
MONEYSTRINGv
NVARCHARSTRINGv
NCHARSTRINGv
BINARYSTRINGv
UNIQUEIDENTIFIERSTRINGv
TIMESTAMPSTRINGv
FLOATFLOATv
BOOLEANBOOLEANv
BLOBSTRINGx
TIMESTRINGv





Was this article helpful?