Netezza to Amazon Redshift Migration

SQLines provides tools to help you convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Netezza to Amazon Redshift.

SQL Server to Redshift Migration Reference

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

Netezza Redshift
1 DISTRIBUTE ON (col1, …) Distribution key DISTKEY (col1) Only one column