DbSchema is an integrated universal database tool, featuring graphical layouts, Relational Data Browse, Query Builder, SQL Editor, schema deployment and synchronization and many more.
Using DbSchema you may increase the productivity of the database work and the quality of the schema design. DbSchema includes modules which are covering the complete area of the database work , from schema design, exploring the data, SQL, deploy of schema over multiple databases, teamwork, backup the schema and data, etc.
The intuitive graphical interaction are making DbSchema the ideal environment for learning databases.
DbSchema is free for personal domestic projects.
DbSchema can work with all relational databases, from MySql, PostgreSql, SqlServer, Derby, Firebird, Oracle, Db2, Informix, HSql, Pointbase, Mimer, Pervasive, Sybase and furhter more.
DbSchema comes with interactive diagrams also called layouts. With the help of the layouts you can easily create tables, columns, foreign keys, callouts with a few simple clicks. This feature will help you also when working with a big database and having lots of table is going to give you a big headache. All you have to do is create a new layout, add tables to the layout by simply drag and drop from the structure tree and add further child tables by pressing the foreign key icon near one of the columns.
The major advantage is a better understanding of the database schema.
2.Relational Data Browse
Tired of having to search for records in multiple tables?
DbSchema has the solution, Relational Data Browse has an amazingly simple and efficient data explorer. You can start viewing the data from a table, add further child tables by pressing the foreign key near one of the column, and the matching records will show on all tables.
You can build a complex relational data browse with optional data filters without any limitation in size, this is a new alternative for the traditional SQL Queries, intuitive and easy to use.
With the SQL Editor you can write and execute SQL Queries, it integrates many features like:
Autocomplete, Execute Scripts, Explain Plan, SQL Formatter and much more.
Complex queries are giving you a hard time?
Build complex queries with a few clicks using our Query Builder.
Simply drag & drop the tables you need from the layout, add further child tables by pressing the foreign key near one of the columns, selecting the columns with different join types, where clauses and ordering, you may build complex queries, without being an advanced SQL developer.
You can view or copy the query generated in the preview window.
The data can be saved in different formats: XML, CSV, XLS, etc?
Try DbSchema, you're going to love it.