Migration to Vertica DB from POstgreSQL DB

Moderator: NorbertKrupa

Post Reply
vinod
Newbie
Newbie
Posts: 1
Joined: Thu Jul 11, 2013 7:42 am

Migration to Vertica DB from POstgreSQL DB

Post by vinod » Fri Jul 12, 2013 10:59 am

Hi,

can anyone please share me the information/document/procedure about migrating the database from PostgreSQL to Vertica Database.
we are currently accessing Vertica through DB Visualizer..

Thanks in advance !

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

Re: Migration to Vertica DB from POstgreSQL DB

Post by nnani » Fri Jul 12, 2013 11:29 am

Hello Vinod,

Welcome to Vertica Forums :)

Migration for PostgreSQL to Vertica will be very much comfortable if it is related to sql scripts.

Because Vertica SQL language is very similar to PostgreSQL infact it hails its SQL language from PostgreSQL.

Some things to take care of ,

There is no support for procedures as we have in PostgreSQL PL/pgsql, so you have to write external procedures in Vertica whicha are basic shell scripts
There are no indexes in Vertica as in PostgreSQL
The use of user defined functions is slightly different then in PostgreSQL
Take care of constraints and duplicates as Vertica has no constraint violation mechanism while loading data.

Documents , you can download in from the Vertica Official Site, there is a provision for Online documents also.

Rest, you can always ask your questions whichever you come across in Migration on this Forum.
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “New to Vertica”