db2 DDL to teradata conversion

General
Teradata Employee

db2 DDL to teradata conversion

Hi

I’m new to Teradata and new this forum... We have EDW running at the moment in DB2 and we're going to Teradata now.

DB2 has 1000 tables in EDW.

My question is....

Are there any tool or utilities to convert the DB2  DDL scripts (1000 tables) into Teradata env..

Please help us and let me know any document ion also.

Thanks

RG

1 REPLY
Enthusiast

Re: db2 DDL to teradata conversion

Do you have ERWIN? You can import the DB2 table DDLs using reverse engineering and then can export in Teradata DDLs. I haven't tried it myself but its worth giving a try...