Migrating From Oracle To Teradata Help With DDL Generation

Database
Highlighted
Enthusiast

Migrating From Oracle To Teradata Help With DDL Generation

Hi All,

As part of my current project there is a need to migrate a number of tables from Oracle to Teradata, i would like to know if there is some sort of an automated way

using which once could create the equivalent Teradata DDLs much faster than doing it one by one manually.

Looking forward for your responses

Thanks

R.Rajeev

6 REPLIES
Teradata Employee

Re: Migrating From Oracle To Teradata Help With DDL Generation

There is  a teradata tool called TMA(teradata migration accelerator) which i hope can do the DDl convertion.

-Aravind

Enthusiast

Re: Migrating From Oracle To Teradata Help With DDL Generation

Hi,

Thanks Aravind

The client is not willing to add another client tool that leaves us just with oracle,infa and TD (database)

Is there any other way or logic which we can follow ?

Thanks

R.rajeev

Teradata Employee

Re: Migrating From Oracle To Teradata Help With DDL Generation

If not willing to use any other software .... no other option. You must do data-type conversion and index changes manually.

HTH!

Regards.

Re: Migrating From Oracle To Teradata Help With DDL Generation

You can use AquaFold Inc. IDE Aqua Data Studio's ER Diagram Generator to generate your Oracle ER Model. Then use the Convert Model Feature which will map your Oracle Table DDL to Teradata DDL.

Enthusiast

Re: Migrating From Oracle To Teradata Help With DDL Generation

Hi ,

Thanks Adeel

Enthusiast

Re: Migrating From Oracle To Teradata Help With DDL Generation

Hi Saravanan,

From my work experience of 6 years in Oracle and 7 years in Teradata, I feel that you can do it manually since client is constraining  you from tool overhead. In addition, doing it manually it is safer. Oracle data type declaration is a bit different and of course you see the Teradata data type declaration is different( Latin,,,,,unicode ...case specific.....blah blah). Understand the functionality and consequence of implementation is important.

As far as I know TD 14.10 supports Number and array data type if need be. RAW, LONG RAW,CLOB,BLOB,BFILE and UDT you need to take care with caution and verify.

Regards,

Raja