Azure SQL Columns Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Azure SQL Columns Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Type Mapping
We match Azure SQL data types to Rivery data types as we extract your data.
The following table shows the mapping of Azure SQL data types to Rivery-compatible types:
| Source data types | Azure SQL database Target datatypes |
|---|---|
| BOOLEAN | BIT |
| SHORT | SMALLINT |
| INT | INTEGER |
| LONG | BIGINT |
| FLOAT | REAL |
| DOUBLE | DOUBLEPRECISION |
| BIGDECIMAL | DECIMAL |
| LOCALDATE | DATE |
| INSTANT | DATETIMEOFFSET |
| LOCALDATETIME | DATETIME2 |
| STRING | NVARCHAR |
| JSON | NVARCHAR |
| BINARY | VARBINARY |
Was this article helpful?