The table displays the mapping for SQL Server as a source to Avro as a target.
| SQL Server | Avro |
|---|---|
| bigint | long |
| bit | int |
| binary | bytes |
| date | string |
| datetime | string |
| datetime2 | string |
| datetimeoffset | string |
| float | float |
| DECIMAL | float |
| Double Precision | double |
| Image | bytes |
| int | int |
| real | float |
| Money | float |
| numeric | float |
| nchar | string |
| char | string |
| varchar | string |
| ntext | string |
| nvarchar | string |
| nvarchar(max) | string |
| smalldatetime | string |
| smallmoney | float |
| Text | string |
| tinyint | int |
| time | string |
| uniqueidentifier | string |
| varbinary | bytes |
| xml | Not Supported |
| varchar(max) | string |
| varbinary(max) | bytes |
| smallint | int |
| bigint identity | long |
| int identity | int |
| smallint identity | int |
| tinyint identity | int |
| decimal ( ) identity | float |
| numeric ( ) identity | float |