DbSchema

DbSchemais definitely ansuccessful and productive database operateenvironment, developed for a simpleaccesstowards thedata and an intuitive understanding of the databases. It can beoperating-system and database independent, with integrated informationbrowse, SQL editor, database-synchronization, round-trip-engineering and team-work attributes. The deviceis a greathelp for developers along with for administrators and method architects.

Key features:

•        Interactive diagrams

Create multiple diagrams ( layouts ) to design and edit your schema. Is enough to move the mouse over a foreign key to see the corresponding columns, to double-click a table to edit it or drag a column over another to create a foreign key. Foreign keys can be drawn joined to tables or to columns, so you can see exactly which columns are joined.

•       Synchronize schema, edit schema online/offline

Working online the schema changes will be applied in DbSchema and in the database. Working offline the schema changes will be done only in DbSchema and saved in the project file. Later you can decide to synchronize the schema with the database and commit the schema changes or refresh changes from Db. You can convert your schema to a different database, upload it on database...

•        Relational data browse  

An amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.

The Sql editor with syntax highlighting and code completion, makes your editing easier, productive and can even be fun. DbSchema supports execution of simple queries or large scripts, with output on screen or spool to file.

•        Sql editor

The Sql editor with syntax highlighting and code completion, makes your editing easier, productive and can even be fun. DbSchema supports execution of simple queries or large scripts, with output on screen or spool to file.

•        Visual Query Builder

Graphically compose complex queries with INNER, OUTER, EXISTS joins, filters and group by clauses.

•        Interactive Web image documentation

DbSchema supports documentation from the ground up, allowing every table, column, index, etc. to have an associated comment or description. DbSchema can generate documentation in visual graphical format, compact (XHTML / SVG) for an easy deploy over web. You can view your schema remote, move the mouse over the tables and columns and read the comments.

•        Save schema design as project file

The DbSchema project file will store the schema design and the layouts with the SQL and Data Browse editors. The project file can be opened from any other computer, even if you cannot connect to the database.

•        Team work

Due the ability to save DbSchema project to file you can share your work in a team, with no need of a physical database. The project file can be stored in a subversion repository and can be updated by each member of the team.