DBArtisan vs. DbVisualizer

DBArtisan is excellent for large institutions with multiple mission-critical databases. It works especially well for cross-platforms RDBMS support. I am mostly familiar with Oracle, but less familiar with SQL Server and Sybase. So I certainly appreciate having a similar interface that allows me to manage those less familiar RDBMS, as this will mean a smaller learning curve. DBArtisan is mostly for DBAs, it is not suitable for developers, I believe the vendor has a separate tool for that

Incentivized

Well suited for medium size to large Oracle system that includes a large and complex database schema with many database objects including functions and triggers. Also well suited for a medium size to large Microsoft SQL Server system with many complex database objects. Its SQL editor and query builder are well suited in developing complex SQL queries.

• The free trial offer was great for me to test the software before purchasing it.
• It monitors queries well and shows resource allocation, as well as detailed stats for each running query.

Incentivized

• Provides simple access to all tables, indexes, views, triggers, stored procedures, etc., to just about every database on the market
• Allows me to develop and run queries in a simple, easy to read and understand manner
• Allows me to create entire new schemas as well as alter existing schemas
• Gives me access to databases without the need to install specific drivers for any particular database

Incentivized

• DBArtisan lacks a utility that does schema or object comparisons, which is a feature in Toad. I find this useful in some situations where I need to find out all differences between Prod and QA for a given schema, for example. DBArtisan doesn't seem to have the capacity to do this.
• I wish there was a way for the tool to warn me before performing a long-running task. For example if I want to re-organize a large table or rebuild an index for a table with millions of rows, it should warn me before executing it, so that I may choose to do it in a different way. Sometimes if I let these long operations run for too long, it freezes the program and crashes DBArtisan. I would rather run it on the DB server, and run it in background so that it doesn't time out, if DBArtisan gave me a warning before execution.
• Idera has taken over Embarcadero. I never heard of or dealt with Idera for support. I don't know if they have same the quality support as before.

Incentivized

• does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
• filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
• altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)

Incentivized

We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

Incentivized

I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.

I have never tried their support so the number above is meaningless

Incentivized

Never used

Incentivized

DBArtisan does not have an in-depth performance analyzer for databases.

Incentivized

[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.

Incentivized

• While it is expensive, it saves us a great deal of time in getting a lot of DB work done.
• The front end is reasonably powerful and significantly more polished than any of the free alternatives

Incentivized

• The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"