Here’s the Deal

SchemaCrawler vs pgModeler

8 0

4 0

When comparing SchemaCrawler vs pgModeler, 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 pgModeler is ranked 10th. 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

TechnologyC++, Qt

Database managementPostgreSQL

Ranked in these QuestionsQuestion Ranking

Common Questions

What are the best relational database design and modelling tools?

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
Diff scripts

Can generate scripts to synchronize a database.

Pro
Reverse engineering

Can generate diagrams from an existing database.

Pro
Export formats

Can export to SQL script file, PNG, SVG or directly to PostgreSQL.

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.