DbSchema Sqlserver Client and Diagram Designer

DbSchema is an Sqlserver database designer featuring interactive diagrams, HTML and PDF documentation, schema versioning and migration, relational data browse, random data generator, visual query builder, SQL editor and database reports.

DbSchema is using its own image of the schema separate from the Sqlserver database. This makes possible to manage different versions of the schema, deploy them on multiple databases and generate migration script.

Further features like HTML5 vector image documentation, virtual foreign keys and relational data browse are helping to easy understand, document and explore databases.

DbSchema Database Designer

Sqlserver Designer

Sqlserver Diagram Designer Using DbSchema you will interact with Sqlserver using interactive diagrams. New tables, columns and indexes can be created directly in the diagram. The diagrams can be exported as HTML vector images.

The diagrams will be saved to project file, in XML format. The project file can be shared in a team. As the project file is storing also the schema design, saving different project files you may hold different versions of the schema.

Video Introduction Read more »

Schema Deployment and Migration

DbSchema is using its own image of the schema, separate from the database. This can be saved as project file.
The local image of the schema can be compared with any database, migration scripts can be generated.
The local image of the schema can be compared also with other project files.

Sqlserver Schema Migration & Deployment

Convert Schema to Sqlserver DbSchema use its own project with schema structure and diagrams, which will be saved to project file. This makes possible to design schema independent from the database and deploy it on multiple databases.

The project file is in XML format. The project file can be stored in GIT and shared in a team.

Restarting DbSchema will open the last saved project file. To ensure the project schema is the same as in the database press 'Refresh schema from database' from the menu. Next you can refresh complete schema or take an action for each difference : merge in DbSchema or in the database.

Video Introduction Read more »

Relational Data Browse

Simultaneously explore data from multiple tables bind via foreign keys. Selecting a record in one table will update the children tables with the matching records. There is no limit for the number of tables to cascade. If the schema is missing foreign keys, you can create virtual foreign keys in DbSchema and use them in relational data browse.

Relational Data Browse
Video Introduction Read more »

Visual Query Builder and Query Editor

Sqlserver visual query builder and query editor

The visual query builder can use Group By, Order by clauses, different joins like left join, exists. The joins are using foreign keys or virtual foreign keys.

The Query editor features text-autocompletion, script execution and graphical explain plan.

Video Introduction Read more »

Database Forms and Reports

Sqlserver Forms and Reports DbSchema Sqlserver forms and reports can be used to build applications or reports and run which can run as Web applications. The reports may use multiple master-detail sections and responsive bootstrap web pages. Forms can include different input fields, radio buttons, images and charts.

Read more »

For a good database design you may need visual database documentation, diagrams and virtual foreign keys. Here you have an sample interactive documentation. Move the mouse over tables and columns to read the schema comments.

Free Trial

Download DbSchema and try it 15 days for free.

Technical Support

Registered and unregistered users may benefit from technical support.

1 Year Renewals Included

Purchase DbSchema and you will get 1 year free updates to new developed features and fixes.

Money Back Guarantee

Not happy with DbSchema ? 30 days after purchase you can claim your money back.

Start using DbSchema right now !

DbSchema can be evaluated 15 days for free.

DbSchema can run on all operating systems: Windows, Linux, MAC.

DbSchema Database Tool