Oracle to Netezza Migration

SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, packages, triggers, queries and SQL scripts from Oracle to Netezza.

Oracle 12c, 11g, 10g and 9i
Netezza 7.x

We also help convert embedded SQL statements in C/C++ (ODBC, Pro*C, OCI), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl/PHP and other applications.

Oracle to Netezza Migration Tools

SQLines tools to help you migrate from Oracle to Netezza:

SQLines SQL Converter Tool

SQLines SQL Converter tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Oracle to Netezza.

SQLines tool converts SQL scripts and standalone SQL statements.

SQLines tool is available in Online and Desktop editions:

Try SQLines Online or download a Trial Version.

Oracle to Netezza Migration Reference

Technical information on migration from Oracle to Netezza.

Last Update: Oracle 12c and Netezza 7.x

SQL Language Elements

Converting SQL and PL/SQL language elements from Oracle to Netezza:

	Oracle		Netezza
1	SQLERRM	Error message text	SQLERRM
2	SQL%ROWCOUNT	Number of processed rows	ROW_COUNT
3	column%TYPE	Derived data type attribute	column%TYPE

Data Types

Converting data types from Oracle to Netezza:

	Oracle		Netezza
1	NUMBER(p,0), NUMBER(p)	Fixed-point number, 9 <= p <= 38	NUMERIC(p)

Built-in SQL Functions

Converting built-in functions from Oracle to Netezza:

	Oracle		Netezza
1	INSTR(string, substring)	Get position of substring in string	POSITION(substring IN string)
2	TO_CHAR(exp)	Convert expression to string	CAST(exp AS VARCHAR(30))

SELECT Statement

Converting SQL SELECT statement and its clauses from Oracle to Netezza:

	Oracle		Netezza
1	SELECT exp FROM dual	Calculate expression	SELECT exp
			SELECT exp FROM _v_dual

CREATE PROCEDURE Statement

Converting CREATE PROCEDURE statement from Oracle to Netezza:

	Oracle	Netezza
1	CREATE OR REPLACE PROCEDURE	CREATE OR REPLACE PROCEDURE
2	param IN \| OUT \| IN OUT datatype DEFAULT default	datatype param ALIAS FOR $1; …
3	IS \| AS	RETURNS INT EXECUTE AS CALLER LANGUAGE NZPLSQL AS BEGIN_PROC
4	END proc_name;	END;
5	/	END_PROC;

PL/SQL Statements

Converting PL/SQL statements and clauses from Oracle to Netezza:

Cursor operations:

	Oracle		Netezza
1	cur SYS_REFCURSOR	Cursor variable	cur RECORD
2	CURSOR cur IS select_stmt	Cursor declaration	cur RECORD
3	OPEN cur; LOOP	Open and iterate through a cursor	FOR cur IN select_stmt LOOP
4	OPEN cur FOR select_stmt; LOOP		FOR cur IN select_stmt LOOP
5	OPEN cur FOR sql_var; LOOP		FOR cur IN EXECUTE sql_var LOOP
6	FETCH cur INTO v1, v2, …	Fetch data	v1 := cur.c1; v2 := cur.c2; …
7	EXIT WHEN cur%NOTFOUND	Terminate loop when no row found	EXIT WHEN NOT FOUND
8	CLOSE cur	Close a cursor	Removed

Flow of control statements:

	Oracle		Netezza
1	EXIT WHEN exp	Terminate loop when exp is true	EXIT WHEN exp

EXCEPTION block:

	Oracle		Netezza
1	WHEN NO_DATA_FOUND	No rows found	IF NOT FOUND statement

Built-in PL/SQL Packages

Converting built-in PL/SQL packages from Oracle to Netezza:

	Oracle		Netezza
1	DBMS_OUTPUT.PUT_LINE(text)	Output a message	RAISE NOTICE '%', text

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to IBM DB2

Migration to Redshift

Migration to Databricks

Migration to Snowflake

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to SingleStore

Application Conversion

Database Reference