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 !
Migration to Vertica DB from POstgreSQL DB
Moderator: NorbertKrupa
Re: Migration to Vertica DB from POstgreSQL DB
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.
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.