dbForge Studio (Edge) vs. Navicat

This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.

Incentivized

Navicat Premium is a very well-rounded tool with a reasonable licensing fee given its feature set. It is primarily suited for technical resources who must work with a variety of different database systems, but who may not be database or command line tool wizards. However, its query building and job batch scheduling feature support end-users as they build competency, and it continues to hold its value even as users outgrow their training wheels. Navicat is probably not so appropriate for DBAs and others for whom database development and management is already a career path; these folks have their preferred toolsets, both vendor-supplied and homegrown, and they might consider the additional licensing cost to outweigh the value they'd personally get out of Navicat.

Incentivized

• Connection manager (we use it through ssh tunnels) works effortlessly.
• Great sync tools for both database schemas and data.
• Storing code snippets to be used when needed.
• Nice code suggestions while typing queries.
• Usually does very well with storing your session and opening all of your sql tabs when opening the apps next time.
• Does very well when executing large sql files (without opening the files into the application that is).
• Pretty good debugging help when a problem occurs in executing a query or a files with multiple queries.

Incentivized

• Really helpful auto-completion.
• Can connect to multiple (different) database types simultaneously.
• Can generate some really impressive charts.
• The new data dictionary tool is great!

• The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
• The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel

Incentivized

• Remote deploy databases
• Clone databases

Incentivized

dbForge Studio (Edge) has a great UI and it's versatile, but it still has some glitches. Its multiple database support makes it possible to stick with only one UI to handle different RDBM systems, even though you have to redefine user credentials for each new connection (no copying/cloning feature for database connections). The Edit View and diagramming features also could be improved.

There is quite a lot to learn because Navicat Premium is a very comprehensive database management and development tool, but it's User Interface is intuitive enough to pick up fairly quickly. I have also referred to the documentation on occasion, and can attest that it is quite good. I feel that it works best on a large monitor, but that's fairly common for this sort of software.

Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.

Incentivized

Very robust online community and well as excellent support staff. Easy to follow video tutorials. Detailed sample configurations are provided with guided walk-throughs via remote classroom instruction. Very fast response from support staff. No internal hires were necessary for support as vendor support staff fully met all technical expertise. 24/7 incident reporting and tracking is great.

Incentivized

Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio

Navicat allows for easier querying of data while still allowing for visualization and modeling

• Saved a TON of time when looking at massive amounts of parent/child data by allowing us to just use the master-detail browser.
• Very little training time needed for employees that are already used to using SQL Management Studio. This is a proper Windows UI application.
• Very cost effective to purchase the standard edition for every employee that needs it, but the free edition does most of what they need too!

Incentivized

• Assisting new employees with understanding our DB
• Reduce debugging and testing time with being able to visualize data/queries
• Allowing non-SQL users to execute queries to get real-time data.

Incentivized