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.
oracle DDL vs Teradata DDL
Moderators: chulett, rschirm, roy
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.
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.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
Something like that will get you close.
Code: Select all
Select
'Create Table Whatever ' As DdlStmt
From
MyMetadataTable
Union All
Select
ColName || ' ' || DataType || '(' || DataLength || ')' As DdlStmt
From
MyMetadataTable
Mamu Kim