Navicat vs. OptInsight

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

• Access via standard html
• Alert notification

Incentivized

• There is room for improvement with customer support and vendor account management
• Onboarding option/support for new team members within the business using the tool
• More product/feature updates and trainings

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

Navicat is superior in allowing us to save complex queries and share them with other users. It is also better at administering the database. It also allows us to easily transfer data and structure to a test database server. This saves a ton of time when working on our dev environment to get access to fresh data.

Incentivized

• Practically speaking, Navicat Premium has enabled our department to support database maintenance and extension, migrations, and customer data reporting and analysis requests, without requiring staffers to be database mavens, thereby extending our limited (non-profit) resources in a significant manner.
• In the long term, we may find our perpetual licenses will age out of usefulness, given that major version updates are (not unreasonably) unavailable for perpetual licensing. However, three years in, we've found it to continue to provide value. And going forward, should a major version upgrade be required, upgrade licensing is available at a reduced cost.
• As we are a non-commercial organization -- part of the California State University system -- Navicat Premium's one-time license cost is low enough to provide a great value for our department, given the large suite of features it offers; at current non-commercial pricing, one perpetual seat costs out at $599. If you are a commercial organization, the "enterprise edition" is what you'll need to purchase, and at $1,299 per perpetual license, it may be tougher to justify the expenditure. However, Navicat Premium's support for a wide variety of database systems does positively differentiate this product!

Incentivized