Here’s the Deal

SchemaCrawler vs SQLeo

8 0

2 0

When comparing SchemaCrawler vs SQLeo, 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

PlatformsWindows, Linux, Mac

TechnologyJava

PlatformsWindows, Linux, Mac

Ranked in these QuestionsQuestion Ranking

Common Questions

What are the best SQL graphical schema viewer / editor / import/export programs?

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
Data compare

Pro
Query builder

Pro
Import / Export

html, insert, text or csv

Pro
Color

Background color per connection.

Pro
Schema compare

Ad
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.