PostgreSQL DB to Vertica DB Migration

PostgreSQL DB to Vertica DB Migration - Can I get a document/process which provides the steps on migrating PostgreSQL to Vertica? Currently we are connecting vertica from DB Visualizer. PostgreSQL Version: 9.1 Vertica Version: 4.1.2 DB Visualizer Version: DB Visualizer Pro 9.0.7 PostgreSQL Data Size: 400GB (50 tables)


  • Options
    Prasanta_PalPrasanta_Pal - Select Field - Employee
    Since DB Visualizer supports PostgreSQL as well as Vertica, so you should be able to migrate the data from PostgreSQL to Vertica. May visit the below URL for more info. http://www.dbvis.com/doc/database-drivers/ Can you copy any table from Oracle to vertica using DB Visualizer?
  • Options
    Thanks for the reply Prasanta. We are looking for a tool which will automatically export postgres schemas and import into vertica DB schemas. DB Vis has only Import and Export options for tables. I guess the Pro edition has this. Anyways, still figuring out options.
  • Options
    edited November 2017

    Use Alteryx tool , it is good

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file