Teradata to Vertica Migration

Moderator: NorbertKrupa

Post Reply
Ramkannnan
Newbie
Newbie
Posts: 1
Joined: Wed Apr 17, 2013 6:33 am

Teradata to Vertica Migration

Post by Ramkannnan » Wed Oct 02, 2013 3:23 am

Hi,

Currently we have a requirement.

Migration from Teradata to Vertica.

From the High Level can some one share me the steps involved in this.

Cheers
Ram

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Teradata to Vertica Migration

Post by nnani » Thu Oct 03, 2013 7:47 am

Hello Ramkannnan,

Welcome to Vertica forums !

On a high level -

1. Extract the Teradata tables using the tpt / fast export utility of Teradata into a file
2. Use the Copy utility / command in vertica to load data from file to table in Vertica
3. Use simple sql script for transformations inside Vertica database from table to table.

You can detail your requirements and the forum is wide open helping you ahead for any issues.

Hope this helps.. :)
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica Migration”