dbForge SQL Tools vs. DbVisualizer

dbForge SQL Complete is well suited for professionals that have to write code all day. In my role in the business intelligence department we are writing SQL pretty much all day. Having a tool that helps us do that faster, in a cleaner way is pretty awesome and something that pays for itself quickly.

Incentivized

Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.

Incentivized

• SQL complete allows you to create custom snippets that allow you to store frequently ran queries in shortcuts. The code can be populated within seconds!
• Another great benefit is custom aliases. If you frequently reference the same tables over and over again it gets tiresome to retype the aliases. Storing these can make your code more consistent and save time.
• SQL complete will also highlight the metadata within your database. For example, if you start typing an insert statement you populate code for all the field names by pressing the tab. This is a real-time saver for wide tables!

Incentivized

• Timed queries that add their result to the result grid for every execution are helpful. Creation of graphs also extremely helpful.
• Query history and auto-recover feature makes sure we don't lose our queries.
• Actions like exporting grids to Excel or other tools is a very easy task.

Incentivized

• Sometimes it can be slow to retrieve the database metadata.
• Updating the software with the activation/deactivation of licenses could be further streamlined.

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

Menus are simple and well organized. You can use the same shortcuts no matter which database engine you are connecting to. Configuration of data source connections is simple while keeping all required options.

Incentivized

I am very satisfied after using this tool. It is a full-stack tool that includes rich features that can be customized set of functionality as per your need. by using this tool:-

• Increased our productivity rate.
• Provides speed up your development work so you can focus on other stuff.

DbVisualizer provides a good value when compared against other 3rd party products with similar features as well as products with similar functionality made by the database vendors. The user interface is good and user friendly / intuitive and easy to learn. It doesn't take too long for an experienced DBA / database developer to come up to speed.

• Spending less time trying to figure out how tables are related thanks to the navigational help in dbForge SQL Complete, which means fixing issues takes less time.

Incentivized

• The institution is of the governmental type, therefore we do not measure the commercial impact of using this tool
• The impact on the benefit of the population is always positive with tools that streamline our processes, and DbVisualizer is one of the best

Incentivized