DbSchema 6
The Art Of Keeping Data Together
DbSchema isn't for everyone, but if you work with or want to
learn to work with relational databases, today's deal is especially
for you!
DbSchema is an efficient and productive universal database
tool that facilitates an intuitive perception of the schema using
graphical layouts, relational data browsing, a query builder, a SQL
editor, schema synchronization and migration tools, and much, much
more. DbScema includes all the major features you would expect from a
sophisticated database tool, and then some!
The database schema is represented in DbSchema using
graphical layouts. This representation is the best way of
understanding the relationality between tables, and is also the key
factor in designing a high-quality database schema. Multiple layouts
can be created for a single schema, each offering a unique
perspective. And you can easily add comments for each table, column or
layout.
Relational Data Browse -- one of the primary tools in
DbSchema -- is an amazingly simple and efficient relational
data explorer that offers simultaneous views of data from multiple
tables. Relational Data Browse features numerous filters, data
sorting mechanisms, and much more. Using it you can explore the
database data in a fast and intuitive way, without writing a single
SQL query!
The Query Builder can build complex queries, with 'Group By'
clauses or differing 'Join' types. The Query Builder is
integrated in the DbSchema layouts, so editing queries can be
done starting from the graphical representation of the schema. Even
better -- during query editing the SQL text is displayed in a preview.
This is a fantastic feature for those interested in learning SQL.
The SQL Editor features text auto-completion, query and
scripts execution, graphical explain plan and offers the option of
saving large results to file.
Schema synchronization features and DbSchema project files
allow the design of the schema to be followed by the deploy of the
schema over multiple databases. This is useful in development teams
where the production database schema needs to be upgraded to the
development one. In addition, DbSchema can convert schemas
between different databases.
DbSchema can also create high quality print-outs. HTML5
images can be generated out of the layout graphical representation of
the schema. The HTML5 images are about 100 times smaller then the same
GIF image, a perfect choice for documenting the database schema. Each
table or column in the layout can be commented and the comments will
be included in the documentation.
Promotion Written by Roger Thomasson
