When comparing Navicat vs SchemaCrawler, the Slant community recommends SchemaCrawler for most people. In the question“What are the best relational database design and modelling tools?” SchemaCrawler is ranked 8th while Navicat is ranked 11th. The most important reason people chose SchemaCrawler is:
The text-based output serves for database documentation, and is designed to be diff-ed against other database schemas.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Navicat Premium supports Amazon Redshift well
Pro It just works
Although it's a paid tool and rather expensive when compared with some of the small indie app developers on the Apple App Store, Navicat seems to have that professional polish and feels very much like a OS X app, not something that's just been ported from Windows or Linux.
Pro Many options for output formats in addition to graphical
The text-based output serves for database documentation, and is designed to be diff-ed against other database schemas.
Pro Extensive and detailed documentation online
Including visuals of the results of command-line option usage.
Pro Free
Cons
Con Need Java
Con Does not work with schema dumpfiles
SchemaCrawler has no methods for dealing with when you only have a schema generated via something like (mysqldump --no-data [options] >schema-only_dump.sql) , and do not currently have access to a live database to connect with.