When comparing Database .NET 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 Database .NET is ranked 12th. 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 Multi database
Supported databases:
- SQL Server
- SQL Azure
- LocalDB
- MySQL
- Oracle
- IBM DB2
- Informix
- PostgreSQL
- HP Vertica
- NuoDB
- Teradata
- Sybase ASE
- Firebird
- SQLite
- SQLCe
- Access
- Excel
- VistaDB
- dBase
- FoxPro
- OleDB
- ODBC
- OData
- Text
- NoSQL
Pro Portable
Pro Diagrams
Can generate diagrams.
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.