All Forums Database
muthu1802 20 posts Joined 01/12
27 Aug 2015
Oracle Table to Teradata DDL

I want to form a teradata table structure for a given oracle table.
Do we have any ways to acheive this ?
Also I heard about ora2td tool which will help to acheive this. but I do not have enough details regarding this tool.
Could someone help with this. If possible please share details regarding ora2td tool.
 
Thanks,
Muthu.
 

Abhishektd 7 posts Joined 06/11
28 Aug 2015

Hi Muthu,
I think there is a tool Teradata aceleration manager provided by Teradata .It will be helpful if you have to do this migration activity for large numner of objects.
If you have to do this for just a couple of tables ,then it will be better to do it manually rather than investing on a tool. You can refer the link below , which will help you in comparing Teradata data types to Oracle data types.
http://docs.oracle.com/html/B10543_01/apa.htm

Thanks & regards,
Abhi

Adeel Chaudhry 773 posts Joined 04/08
30 Aug 2015

There is a small utility ( i wouldn't call it a tool) to do this task, but even that doesn't generate the output which can be used as-is .... meaning it involves manual effort to get the best output.
 
How many tables you wish to migrate?

-- If you are stuck at something .... consider it an opportunity to think anew.

muthu1802 20 posts Joined 01/12
28 Oct 2015

300+ Tables. Aplologize for the late response.

Abhishektd 7 posts Joined 06/11
25 Nov 2015

Try AQT (Advanced Query tool).

Thanks & regards,
Abhi

You must sign in to leave a comment.