Oracle to Teradata Database Migration Tool

[surapurajup]

Hi,

I am interested in knowing if there exists any tools in Teradata or in market, which can help me in migrating the Oracle DB objects to Teradata.

Any info in this regard will be of great help to me.

Thanks,

[drenugopal]

Automated Application Migration tool (AAMT) is used to migrate Oracle DB Object into Teradata SQL.

please refer the below url.
http://www.teradata.com/t/page/107592/index.html

[surapurajup]

Thanks Renugopal for the information.

[sriniviz]

Can any one help me to get documentation on Oracle to Teradata migration..it's urgent
thanks
SRINI

[Gruutal]

Hi Sriniviz,

What you can use is an open source ETL tool to migrate Oracle database to Teradata. Open source tools, like Talend, are free to download.

Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

For more information: http://www.talend.com/

[wonn1377]

I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access,MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool

Download Free : http://www.dbload.com

[rocket_science1]

It seems fastreader is popular tool for large migrations from oracle these days.
adding the link to steps how to migrate data from oracle-to-teradata
http://www.wisdomforce.com/resources/docs/FastReaderBestPracticesforTeradata.pdf
The document title Best Practices for high-speed data transfer from Oracle to Teradata using FastReader

[eejimkos]

Hello,

How can I download Automated Application Migration tool (AAMT)

which is used to migrate Oracle DB Object into Teradata SQL.

Thank you very much.

[AshishPatil]

Hi,

We are migrating from oracle to teradata. Can anyone please guide about how we can proceed for migration. Our current production environment details are as below,

ETLTool - Informatica 8.6 

DAC 10.1.3.4.1 

Database - Oracle 10g R2 

DB schema version- 7.9.6.2 

We have 2 GB of Informatica repository with 2500 mappings and database of 4.5 TB 



So if with this environment if v are moving to Teradata where we need to do changes and where we don't need as such? 

What changes we need to ensure for above scenario considering above tools and oracle DB version. 



Is any modifications required in mapping or repository bcoz we r using Oracle_BI_DW repostry which is actually for oracle DB? 

We found in informatica doc for teradata DB they recommend Oracle_BI_DW_Teradata repository provided by OBIA. so if we will use this repo. do we need to do all the customization again on this repo. which we did on our current repo.? or else can we export all those customized mappings to new base repo.? 



What is the process for data migration? 

Is there any free source tool available which we can use for migration? i have read about Automated Application Migration tool (AAMT) but it's teradata owned. is it available as free source ? 



Please guide. 

Thanks in advance.