DbSchema is a complete database tool, oriented towards usability, facilitating an easier understanding of schemas and logical browsing of database data. While many of the existing tools require advanced knowledge of SQL language and database design, using DbSchema you can understand the database structure at a glance and explore its data just using a mouse. DbSchema is an outstanding tool due to the intuitive approach to databases, which makes it easy to use by beginners as well as professionals.
With a single program, database managers, programmers or regular users can save time and money in the design, development and maintenance of enterprise relational databases.
DbSchema emphasises database structure in an easy-to-use interface, that simplifies understanding of schema and supports efficient interaction with the data. By using DbSchema diagrammed layouts you will get a clear and concise picture of your schemes. Exploring data can be done as easy as browsing the Internet. Beside this, you may use the Query Builder or the Sql editor to edit and execute complex Sql queries.
The DbSchema layouts shows tables, columns, primary keys, foreign keys, indexes, etc all in a simple and concise diagram. Layouts allow you to directly edit all the above objects as well as add comments and navigate through the schema. You can create multiple layouts, each focused on a specific part of your schema. Everything is saved into a single project file, which allows you to work in your schemas without a live connection to a database. All schema changes can later be applied to the live database by a simple synchronization feature.
Relational Data Browse, one of the primary tools in DbSchema is an amazingly simple and efficient data explorer. Using drag&drop you can view data from groups of related tables, while still keeping track of the relations between them. This allows you to build complex Browse Trees, of unlimited size. Within a Browse Tree, you can set data filters, enable sorting, edit or insert new data records. Tree browsing is an excellent alternative to traditional SQL queries, since it's intuitive and easy to use. And your browse trees can be saved within the project, so that you can later reopen them, and continue your work, without having to recreate them all over again.
Query Builder uses a similar diagram to layouts, that allows you to build complex queries using several join types, group by, filters and so on. All you have to do is drag tables from a layout into Query Builder panel, and check the columns you want to appear in your result. Build sophisticated queries, is possible and simple, even if you are not an SQL expert!
For regular SQL work, you may use the SQL Editor to execute single or multi queries as well as scripts and view the result on screen or spool it into a file. And while working you can enjoy all the nice productivity enhancing features, like Syntax Highlight and Code Completion.
Database connectivity is implemented using standard JDBC drivers, allowing DbSchema to work with almost all databases, as long as they provide a suitable driver, like Oracle, MySql, Postgres, Db2, MSSql, Sybase, Firebird, Derby, Mimer and many others. Using DbSchema reverse engineering and conversion features you can convert a database schema between different databases. You can also export database data as SQL script files to populate other databases. Using all available DbSchema features you can easily migrate from one database to another.
Adding comments to your schema may bring crucial benefits during the implementation and maintenance phases of your project. DbSchema allows you to add comments to schema elements, and to easily access then while in layout, in the form of quick tooltips. Later you can generate interactive XHTML documentation files, with all the comments included. XHTML files can also contain a vector image representation of the entire layout, providing for a precise and complete documentation that can be opened using an Internet browser. This documentation even has the benefit of providing similar comment tooltips for tables and columns when the mouse hovers over these elements.
DbSchema is suitable for team work as well as for single users! Since projects are stored in their own XML project file, they can be easily added to your source control software (CVS, SVN, SourceSafe, etc...) and shared by a team. Before commiting your changes all you have to do is synchronize your version with the current one in the repository, using the synchronization feature provided by DbSchema, which also includes synchronization with a live database, to keep every database instance in sync.
Software has been tested with good results on large and very large databases, including databases in excess of 1000 tables. On http://www.dbschema.com you will find interesting presentation videos, tutorials, as well as links to installation kits, suitable for Windows, Linux and Mac OS.
DbSchema is available as a 30-day trial software.
Registration is available as Personal (127$), Commercial (198$) and Academic License (63$).
About Wise Coders Solutions:
Wise Coders Solutions has been founded in 2006, targeted towards development of effective and efficient database applications. Large experience with production systems, database scalability and performance issues, encouraged us to design a tool with a distinct approach to databases workflow.
0 comments:
Post a Comment