oracle DDL vs Teradata DDL

iskapalli · Post by **iskapalli** » Mon Oct 10, 2011 6:27 am

HI,

I have a requirment where I need to convert oracle DDL to teradata DDL.

Is it possiblae? if yes can you provide me some tips.

BI-RMA · Post by **BI-RMA** » Mon Oct 10, 2011 6:48 am

Hi iskapalli,
By doing what? Read a DDL-file and replace key-words?

It is probably better to analyse data-dictionary-tables on Oracle, use a mapping-table to get the corresponding data-type for Teradata as compared to Oracle and generate your DDL accordingly.

chulett · Post by **chulett** » Mon Oct 10, 2011 8:04 am

From what little I've seen of Teradata, you don't want a direct 'port' of your Oracle tables to Teradata tables. While you certainly can, they really should be redesigned to take advantage of the unique aspects of the Teradata architecture. Your Teradata Architect or DBA should be able to provide guidance on that subject.

kduke · Post by **kduke** » Mon Oct 17, 2011 8:13 am

I seem to do this a lot. I would post examples of both. You should have tools to generate DDL from tables in existence. Next read system tables and put column names and data types and lengths in your our metadata table. Then you can probably write a SQL statement to loop thru all the columns on one table and create column and data type with length when needed. Then all you need is the create table in front of that.

Code: Select all

Select
   'Create Table Whatever ' As DdlStmt
From
   MyMetadataTable
Union All
Select
   ColName || ' ' || DataType || '(' || DataLength || ')' As DdlStmt
From
   MyMetadataTable

Something like that will get you close.