Oracle to Teradata Database Migration Tool

Third Party Software

Oracle to Teradata Database Migration Tool

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,
8 REPLIES
Enthusiast

Re: Oracle to Teradata Database Migration Tool

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

Re: Oracle to Teradata Database Migration Tool

Thanks Renugopal for the information.

Re: Oracle to Teradata Database Migration Tool

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

Re: Oracle to Teradata Database Migration Tool

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/

Re: Oracle to Teradata Database Migration Tool

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

Re: Oracle to Teradata Database Migration Tool

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

Enthusiast

Re: Oracle to Teradata Database Migration Tool

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.

Enthusiast

Re: Oracle to Teradata Database Migration Tool

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.