When comparing SQLeo vs SchemaCrawler, the Slant community recommends SchemaCrawler for most people. In the question“What are the best SQL graphical schema viewer / editor / import/export programs?” SchemaCrawler is ranked 4th while SQLeo is ranked 13th. 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 Data compare
Pro Query builder
Pro Import / Export
html, insert, text or csv
Pro Color
Background color per connection.
Pro Schema compare
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 Java
Needs JRE 1.7+
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.