DbSchema vs. Navicat

Well suited to a team working directly in the physical modeling space.

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

• Many database platforms supported
• Direct database integration - option to have model actions reflected immediately in database.
• Test data generation with Groovy scripting for control over specific profiles

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!

• Logical data model integration is weak. Need way to update existing models with changes
• Conceptual data modeling is missing

Incentivized

• Remote deploy databases
• Clone databases

Incentivized

DbSchema does a number of things very well, but is not as full featured as many customers will want

Incentivized

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.

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

Some of the other Tools are no longer supported, and DbSchema is much less expensive than most of them.

Incentivized

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

• DbSchema is very inexpensive, and functional, so easy to get a team started

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