When comparing ERBuilder vs SchemaCrawler, the Slant community recommends ERBuilder for most people. In the question“What are the best database design programs?” ERBuilder is ranked 8th while SchemaCrawler is ranked 9th.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Ease of use
Pro Affordable
Very affordable compared to pricey alternatives.
Pro Supports many databases
Pro ER Builder is easy to use and a complete modeling tool
Very interesting tool, powerful and easy to use. Can do reverse and forward engineering, generate SQL script, and more.
Pro Lightweight
Small install size.
Pro Supports Amazon Redshift data modeling
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.