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)
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?
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.
Use Alteryx tool , it is good
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
