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?
Best windows client tools for Vertica?
+1[duplicate 
] see comment below.
+1Hi!
- 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.
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.
+1Any response from the Vertica employees on their tool of choice? DBeaver doesn't scale well
+2DbVisualizer
Get the free version and license:
https://www.vertica.com/blog/dbvisualizer-free-for-vertica-distribution-updates/
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.
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
