The SQL Editor features text autocompletion and explain plan. The graphical query builder features filters, JOINS, GROUP BY and ORDER BY.
The generator is using reverse regular expressions as well as numeric, date or Groovy configurable patterns.įor editing SQL queries you can use the Visual Query Builder or the SQL Editor. Vector images are much smaller compared to bitmap images.ĭevelopers and testers are using it for generating test data. Table and column comments can be read as mouse-over tooltips.
HTML5 or PDF documentation can be generated with vector image of the schema. Using DbSchema you can document each table and column.
Large databases needs good documentation. The tool can be also used to edit the data. Relational Data Browse will help to visually explore data from multiple tables, similar with SQL join queries. If your schema is missing foreign keys you may create virtual foreign keys.
You can cascade in as many tables as you like. First start with one table and then open further tables having foreign keys to the first table. Relational Data Browse is a module for simultaneous exploring data from multiple tables.
Layouts will be saved to model file and can be later reopen. Tables, columns and foreign keys can be edited directly in the layout. To get a better representation of the schema you can create multiple layouts with the same or different tables. This schema can be compared and deployed on any database, migration scripts can be generated.ĭbSchema use layouts (diagrams) to represent the database schema. The model file can be shared in a team using GIT.ĭbSchema can connect to different databases without affecting the schema model. Saving different versions of the same schema model and comparing them you can generate database migration scripts. The schema model is independent from the database and can be created or compared with any other database. DbSchema may help you to document the database schema and generate HTML5 documentation, create and compare the schema with multiple databases and generate schema migration scripts, easy explore data from the database using Relational Data Browse, generate random data, visual edit SQL queries, edit SQL scripts and create HTML reports.ĭesign Schema in a Team, Deploy and MigrateĭbSchema reverse engineers the schema from the database in its own model. If you are programmer, system architect or database administrator, DbSchema is one of the tools which may help you during your daily work. (We're attempting to modularize a single databaseīy schema instead of using multiple databases.DbSchema isn't for everyone, but if you work with or want to learn to work with relational databases or MongoDb, today's deal is especially for you! This is due to segregation of app database objects by schemas instead of by separate databases. It's also worth noting that my DB projects target individual schemas within the same database. However, I do have references to dbschema files that also reference the same server dbschema file. I do not have references to multiple server dbschema files. In this DB project I have a single reference to a server dbschema file. I need to include the deploy manifest file though to ensure the pre and post scripts are included in the comparison but when I specify the deploy manifest file I get an error stating "The target model contains 2 server options If I run the comparison without specifying the deploy manifest file it works (despite receiving serveral errors/warnings that references can't be resolved - but I'm running VSDBCMD to compare two versions of dbschema files from the same DB project.