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
[NO] AFTER JOURNAL
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
CHARACTER SET LATIN 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