Features
DbSchema database tool focus on making your daily work easier, faster and more productive.
All features have been engineered so that their usage saves you time, makes their usage logic and comfortable
and improves your work flow.
Besides the complete list of features you can read short presentations about:
Import database schemes
- Connect to a growing list of JDBC compatible databases, including Oracle, MySQL, PostgreSQL, DB2 for Windows/Linux, Cache, DaffodilDB, FrontBase, HSQLDB, Informix, JavaDB/Derby, Microsoft SQL Server, Mimer, Pervasive, PointBase, Sybase SQL Anywhere, Sybase ASE.
- Importable schema include tables, foreign keys, procedures, triggers, sequences, and more.
- Save imported schema as XML files in a database independent format.
Edit database schema
- Edit tables, columns, indexes, foreign keys, procedures, triggers, sequences and comments.
- Edit your schemes Graphically using Layouts
- Create and use multiple Layouts inside a project
- Drag, pan and zoom Layouts using simple mouse movements
- Generate SQL statements directly from schema graphical Layout
- Change schema data types from one database to another
- Generate schema scripts to any particular database
- Edit schema offline
Browse database data
- Simultaneously browse data from multiple tables.
- Paginate browse data.
- Single or multiple views.
- Insert, update, and delete records.
- Order and filter the browsed data.
- View Large Objects (LOBs) fields as image, html, text or using an external application.
- Save the browse work together with the project.
Edit and execute SQL
- Syntax highlights cover database keywords, functions, table names, and view names.
- Auto-complete of table, view and column names.
- Execute SQL statements individually or as scripts.
- Keep multiple SQL result panes active and automatically refresh query results.
- Paginate and order SQL results.
- Explain plan.
- Save the SQL editing work together with the project.
Schema Synchronization
- Synchronize project schema with another project or database.
- List schema differences.
- Select which differences to keep, either on local or remote schema.
- Generate Merge SQL scripts based on schema differences.
- Upload differences on to database, with automatic step by step execution.
- Synchronize schemes offline ( useful for team work ).
Scripts and documentation
- Generates SQL schema creation scripts for any database.
- Easily document and comment tables, columns, foreign keys, indexes, etc.
- Generates schema specification as an HTML document.
- Print schema Layouts with precise control.
- Generates schema Layout image files, in a few formats (PNG [raster] or SVG [vectorial])
- Create, edit, and maintain database templates.
