Likelihood to Recommend 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.
Read full review 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.
Read full review Pros 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! Read full review Access via standard html Alert notification Read full review Cons Sometimes it can be slow to retrieve the database metadata. Updating the software with the activation/deactivation of licenses could be further streamlined. Read full review Navicat Premium's documentation can be hit-or-miss, as there are several versions available, and it's not always clear which documentation is current for the version at hand. Navicat Premium's query building interface is not as easy to use or feature-rich as standard IDE and text editor tools, and I've had some issues in the most recent release build with queries auto-running in the middle of making edits, causing a lack of responsiveness in the inbuilt editor -- however, Navicat offers users the ability to edit queries via an external editor, which mitigates these issues to some degree. In the data browser view, paged data navigation sometimes behaves unexpectedly or fails to work whatsoever, requiring a session restart to correct. The process of saving a data export file is cumbersome, requiring navigation through several windows, and I believe it could be significantly streamlined to improve user experience. Read full review Support Rating 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.
Read full review Alternatives Considered 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. Read full review While
Sequel Pro is a great shareware tool, it's limited to MySQL databases; while our department does use MySQL databases, we also use Oracle databases, so Navicat Premium's multi-product support is an absolute requirement. Navicat Premium also provides data browser support, including filtering, to empower less technically-minded users to query and manipulate databases, an option not available in
Sequel Pro . And the job scheduling and batching features of Navicat Premium further distinguish it above the admirable, if limited,
Sequel Pro .
Read full review Return on Investment 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. Read full review Similar features to OEM provided very easy to use, out-of-the-box functionality. No large infrastructure changes were needed to deploy and install. Read full review ScreenShots dbForge SQL Tools Screenshots