Teradata to EsgynDB Migration

SQLines provides tools and services to help you transfer data, convert database schema (DDL), stored procedures, functions, queries, SQL and BTEQ scripts from Teradata to EsgynDB (powered by Apache Trafodion).

We also help convert embedded SQL statements in C/C++, C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl/PHP, Python and other applications.

Teradata 15, 14, 13.x, 12, V2R6 and V2R5
EsgynDB

SQLines SQL Converter Tool

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

SQLines tool converts SQL scripts and standalone SQL statements.

Try SQLines Online or download Desktop version.

Teradata to EsgynDB Migration Reference

Technical information on migration from Teradata to EsgynDB.

Data Types

Converting data types from Teradata to EsgynDB:

	Teradata		EsgynDB
1	CHAR(n)	Fixed-length string	CHAR(n)
2	DECIMAL(p,s)	Fixed-point number	DECIMAL(p,s) p <=18	NUMERIC(p,s) p >18
3	INTEGER, INT	32-bit integer	INT
4	TIMESTAMP(p)	Date and time with fraction	TIMESTAMP(p)

SELECT Statement

Converting SQL queries from Teradata to EsgynDB:

	Teradata		EsgynDB
1	SEL keyword		Converted to SELECT
2	(NAMED alias)	Define an alias for expression	AS alias

QUALIFY clause conversion:

Teradata	EsgynDB
SELECT c1 FROM t1 WHERE c1='A' QUALIFY ROW_NUMBER() OVER (PARTITION by c1 ORDER BY c1) = 1	SELECT * FROM (SELECT c1, ROW_NUMBER() OVER (PARTITION by c1 ORDER BY c1) rn FROM t1 WHERE c1='A' ) WHERE rn = 1

CREATE TABLE Statement

Converting CREATE TABLE statement from Teradata to EsgynDB:

	Teradata		EsgynDB
1	MULTISET	Allows duplicate rows unless an unique key defined	Keyword not required, removed
2	[NO] FALLBACK	Store a row copy	Clause removed
3	[NO] BEFORE JOURNAL	Store before and after images of data	Clause removed
3	[NO] AFTER JOURNAL	Store before and after images of data	Clause removed
4	COMPRESS (val, …)	Column values to compress	Clause removed
5	CHECKSUM = DEFAULT \| val	Calculate checksum	Clause removed
6	DEFAULT MERGEBLOCKRATIO	Combine small blocks	Clause removed
7	PRIMARY INDEX (col, …)	Hash partitioning	STORE BY (col, …)
8	UNIQUE PRIMARY INDEX	Unique hash partitioning	UNIQUE constraint

Column options and attributes:

	Teradata		EsgynDB
1	DEFAULT exp	Default value	DEFAULT must be specified before NOT NULL
2	TITLE 'title'	Column title	Removed from CREATE TABLE, can be used as alias in queries
3	FORMAT format'	Display format	Removed from CREATE TABLE
4	CHARACTER SET name	Column character set	CHARACTER SET name
4	CHARACTER SET LATIN	Column character set	Removed
5	[NOT] CASESPECIFIC	Case sensitive comparison	[NOT] CASESPECIFIC
6	COMPRESS val \| (val, …)	Column values to compress	Clause removed

SQL Statements

Converting SQL statement from Teradata to EsgynDB:

	Teradata		EsgynDB
1	COLLECT STATS \| STATISTICS	Collect table statistics	UPDATE STATISTICS	Options are different
2	DEL FROM tab	Delete rows	DELETE FROM tab

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