Netezza to Azure SQL DW datatype recommended mapping following successful DM Jumpstart POC:
| Netezza | Azure SQL DW |
| NATIONAL CHARACTER VARYING | NVARCHAR |
| NATIONAL CHAR VARYING | NVARCHAR |
| NATIONAL CHARACTER | NCHAR |
| CHARACTER VARYING | VARCHAR |
| CHAR VARYING | VARCHAR |
| CHARACTER | CHAR |
| TIMESTAMP | DATETIME2 |
| BOOLEAN | BIT |
| BYTEINT | TINYINT |
| INT1 | TINYINT |
| INT2 | SMALLINT |
| INT4 | INTEGER |
| INT8 | BIGINT |
| INTEGER | INT |
| FLOAT4 | FLOAT(24) |
| FLOAT8 | FLOAT(53) |
| DOUBLE PRECISION | FLOAT(53) |
| DOUBLE | FLOAT(53) |
| TIME WITH TIME ZONE | DATETIMEOFFSET |
| TIMETZ | DATETIMEOFFSET |
| TIME WITHOUT TIME ZONE | TIME |
| NUMERIC | NUMERIC |
| DECIMAL | DECIMAL |
| DATE | DATE |
Netezza to Azure SQL DW function mapping indicative after successful DM Jumpstart POC:
| Netezza Function | SQL DW Function |
| INT2(column) | CAST(COLUMN AS SMALLINT) |
| INT4(column) | CAST(COLUMN AS INT) |
| INT8(column) | CAST(COLUMN AS BIGINT) |
| HASH(column,0) | HASHBYTES('MD5', column) |