Best windows client tools for Vertica?

usao

We have been using RazorSQL, but noticed that there are several annoying issues with this tool when running against Vertica. Is there a "better" client to use? What do most people use here?

sKwa

[duplicate ] see comment below.

sKwa

Hi!

• DBeaver
• DBVisualizer
• TOAD
• AquaStudio
• SQuirreL
• SQL Workbench/J
• dbcli/vcli
• vsql/psql
• many others ...

I found the best support for Vertica RDBMS is in DBVisualizer:

• DbVisualizer optimized for Vertica
• DbVisualizer Free for Vertica
• Vertica Integration with DbVisualizer: Connection Guide

PS:

• Personally I prefer vsql.
• A lot of customers uses in DBVis.

krishnamraju

Yes dbvisulizer is best out all, but it is also had disconnection issues when load is very high servers. Vsql is a command line tool , not user friendly.

abtsantosbenten

Any response from the Vertica employees on their tool of choice? DBeaver doesn't scale well

Jim_Knicely

DbVisualizer

Get the free version and license:
https://www.vertica.com/blog/dbvisualizer-free-for-vertica-distribution-updates/

dprutean

If is about scalability I would recommend DbSchema designer for Vertica. The tool is diagram-oriented and scales nice on large databases. The tool loads the schema locally, so you can deploy or compare with other databases, generate migration scripts.

One more free interesting tool you can find from the same company is dsql. Is a command line client. If you have to deal with multiple databases (can be also different Rdbms) can do some magic operations and save a lot of time.