Netezza to Microsoft SQL Server Migration

SQLines provides tools to help you convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Netezza to Microsoft SQL Server (MSSQL, MS SQL), Azure SQL and Azure Synapse.

Databases:

  • Netezza 7.x
  • Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 and 2005

Migration Reference

Built-in SQL Functions

Converting string functions:

Netezza SQL Server
1 RPAD(string, len, pad) Pad the right-side of string LEFT(string + REPLICATE(pad, len), len)

Converting datetime functions:

Netezza SQL Server
1 TO_TIMESTAMP(string, format) Convert string to timestamp CONVERT(DATETIME, string, style)

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses.

For Synapse:

Netezza Synapse
1 PRIMARY KEY (col) Primary key constraint PRIMARY KEY NONCLUSTERED (col) NOT ENFORCED
2 UNIQUE (col) Unique constraint UNIQUE (col) NOT ENFORCED