Page 1 of 1

Teradata to Vertica Migration

Posted: Wed Oct 02, 2013 3:23 am
by Ramkannnan
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

Re: Teradata to Vertica Migration

Posted: Thu Oct 03, 2013 7:47 am
by nnani
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.. :)