DbSchema vs. Navicat

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

Incentivized

I was tasked with migrating data from our local PostgreSQL DB to an Amazon RDS instance. I expected this to be a difficult job, but Navicat's migration wizard made it fairly straightforward. I think that it's more geared towards professional users, although not necessarily database practitioners. Non pros might do better with the new Navicat Lite edition.

• 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

• Easy to understand
• Simple UI/UX
• Easy to connect data

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

Incentivized

• Filter table
• Save to external file

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

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.

Incentivized

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

Incentivized

• Similar features to OEM provided very easy to use, out-of-the-box functionality.
• No large infrastructure changes were needed to deploy and install.

Incentivized