Using DbSchema reverse engineering and conversion features you can convert a database schema between different databases. And while working you can enjoy all the nice productivity enhancing features, like Syntax Highlight and Code Completion.ĭatabase 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. Build sophisticated queries, is possible and simple, even if you are not an SQL expert!įor 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. 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. 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. 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. Tree browsing is an excellent alternative to traditional SQL queries, since it's intuitive and easy to use. Within a Browse Tree, you can set data filters, enable sorting, edit or insert new data records. This allows you to build complex Browse Trees, of unlimited size. Using drag&drop you can view data from groups of related tables, while still keeping track of the relations between them. ![]() Relational Data Browse, one of the primary tools in DbSchema is an amazingly simple and efficient data explorer. All schema changes can later be applied to the live database by a simple synchronization feature. Everything is saved into a single project file, which allows you to work in your schemas without a live connection to a database. You can create multiple layouts, each focused on a specific part of your schema. Layouts allow you to directly edit all the above objects as well as add comments and navigate through the schema. The DbSchema layouts shows tables, columns, primary keys, foreign keys, indexes, etc all in a simple and concise diagram. Beside this, you may use the Query Builder or the Sql editor to edit and execute complex Sql queries. Exploring data can be done as easy as browsing the Internet. ![]() ![]() By using DbSchema diagrammed layouts you will get a clear and concise picture of your schemes. 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.ĭbSchema emphasises database structure in an easy-to-use interface, that simplifies understanding of schema and supports efficient interaction with the data. DbSchema is an outstanding tool due to the intuitive approach to databases, which makes it easy to use by beginners as well as professionals. 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 a complete database tool, oriented towards usability, facilitating an easier understanding of schemas and logical browsing of database data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |