Teradata to Oracle Database Migration Tool for Free

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Teradata to Oracle Database Migration Tool...

Rate Topic

Display Mode

Topic Options

Author

Message

Kir Bojo

Posted 3/13/2007 6:44:21 AM

Junior Member

Group: Forum Members
Last Login: 3/13/2007 6:22:00 AM
Posts: 12, Visits: 1

Hi,

I am interested in knowing if there exists any tool in the market for free, which can help me in migrating the Teradata DB objects to Oracle 10g.

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

Thanks,

Kir Bojo..

Post #6856

Vincent McBurney

Posted 6/14/2007 9:56:09 PM

Junior Member

Group: Forum Members
Last Login: 4/22/2008 1:21:41 AM
Posts: 11, Visits: 12

Oracle have a migration workbench that they use to migrate customers from other databases. It works for the most common platforms like SQL Server and DB2 but I don't know if it works with Teradata. One problem is that you Teradata database data model should be customised and optimised for Teradata and not suitable for a direct migration to Oracle.

You could try reverse engineering your database model in a modelling tool such as ErWin, adjusting the model to suit Oracle and creating the table structure on Oracle. Then use an ETL tool or exports and imports to move the data between the two.

Vincent McBurney
blogs.ittoolbox.com/bi/websphere

Post #7885

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:13pm