DbSchema is a diagram-oriented database, Windows PC software that supports all relational databases and many Non-SQL, such as MySql, Cassandra, PostgreSql, MongoDb schema display, Redshift, SqlServer, Azure, Oracle, Teradata and more.
With Db Schema you can design the schema with or without a database, save the design as a project file, deploy the schema to multiple databases, and share the design on a team. Built-in tools allow you to visually explore database data, generate and run queries, generate random data, create application or report forms, and more. It can be evaluated 15 days for free, no registration is necessary. It can work on all operating systems.
Db Schema is a compilation for large schemas and complex databases. Build meaningful relationships between tables and document the schema. Discover DbSchema layouts, virtual foreign keys, relational data exploration, interactive PDF documentation, and many other features.
Features and highlights
Import database schemas
Load JDBC driver
Connect to any JDBC compliant database. Several DBMS have already been tested, but will be added later.
Los DBMS probados actualmente incluyen: Oracle, MySQL, PostgreSQL, DB2 para Windows / Linux, Cache, DaffodilDB, FrontBase, HSQLDB, Informix, JavaDB / Derby, Microsoft SQL Server, Mimer, Pervasive, PointBase, Sybase SQL Anywhere, Sybase ASE.
The schema import includes: tables, views, foreign keys, procedures, triggers, sequences, and comments.
Edit database schema
It uses a level of abstraction between the schema representation of the internal database and any particular database.
Edit tables, columns, indexes, foreign keys, procedures, triggers, sequences, and comments.
Edit your schemas graphically using layouts, including: tables, views, foreign keys, etc.
Create and use multiple designs within a project.
Drag, pan, and zoom designs with simple mouse movements
Supports drag and drop from project tree to graphic design.
Highlight Foreign keys for a given table, which are fired on drop events.
Generate SQL statements directly from the graphic design schema.
Generate schema scripts to any particular database.
Change the schema data types from one database to another.
Edit offline support scheme.
Find data from the database
Browse data from multiple tables simultaneously.
Set filters on browsing data.
Sort the navigation data in one or more columns.
Unlimited browsing depth.
Pages browse the data.
Single or multiple record views.
Insert, update and delete records.
View large object (LOB) fields as image, html, text or using an external application.
Saves the browsing sessions to the project file, which can then be browsed again.
Edit and run SQL.
Edit SQL statements.
Syntax highlighting that covers database keywords, functions, tables, and view names.
Auto completion of tables, views and column names.
Click and quickly display tables or columns in the SQL pane and display them in Design.
Execute SQL statements individually or as scripts.
Paginate and sort the SQL results, after the query execution.
Maintain multiple SQL results panels and update query results.
Explain the SQL execution plan.
Saves the working sessions of the SQL scripts in the project file, which you can continue later.
Synchronize the project schema with another project or database.
List the schema differences.
Select which differences to keep, either on the local or remote schema.
Generate merge SQL scripts based on schema differences.
Load differences into the database, with automatic step-by-step execution.
Synchronize schemas offline, allowing teamwork.
Scripts and documentation
Generate SQL schema creation scripts for any database.
Document tables, columns, foreign keys, indexes, etc. adding comments.
Generate schema specification as HTML document.
Print outline designs with precise control of the actual print size, using the Zoom print feature.
Generates outline design image files, in some formats (PNG [raster] o SVG [vectorial])
Provides a database template system, which allows you to create, edit, and maintain database templates.
Several Database Templates are already supplied, but new ones can also be learned by connecting to the target database.
Note: 15-day trial version (can be extended to 30 days).