When comparing SchemaCrawler vs SQL Power Architect, the Slant community recommends SQL Power Architect for most people. In the question“What are the best relational database design and modelling tools?” SQL Power Architect is ranked 3rd while SchemaCrawler is ranked 8th. The most important reason people chose SQL Power Architect is:
Can convert databases and copy the data from tables.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
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
Pro Convert
Can convert databases and copy the data from tables.
Pro OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.
Pro Reverse engineering
Pro Drag and Drop
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.
Con The manual is not free
The SQL Power Architect User Guide costs $ 99.