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) |