DbSchema Features

DbSchema is available under two editions:

DbSchema Free Edition is suitable for personal use, for querying databases, designing small schemes ( up to 12 tables ), limited browse of data, etc. Up to 3 graphical layouts can be created and edited.

DbSchema Ultimate Edition is suitable for all projects, from small, medium to large. Design your project, create multiple layouts and comment them. Save the project to file and later reopened. Generate SQL scripts, documentation files, etc.. Using Relational Data Browse view the database data from as many related tables as you want, save the browse to the project file, etc. Schema can be uploaded on the database or converted to a different database vendor.

		DbSchema Free Edition	DbSchema Ultimate Edition
Reverse engineering	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.
	Import schema with tables, foreign keys, procedures, triggers, sequences, and more.
	Save imported schema as XML files in a database independent format.
	Edit the database specific settings, data types, etc.
	Connect to any new database and learn on the fly the data types, database settings, etc.
	Change the project RDBMS and convert the schema to a different database vendor.
Design	Edit tables, columns, indexes, foreign keys, procedures, triggers, sequences and comments.
	Drag, pan and zoom Layouts using simple mouse movements
	Generate SQL statements directly from schema graphical Layout
	Generate schema creation scripts
	Edit schema when no database is available
	View multiple layouts in the same time
	Search for a table in the layout
Reverse engineering	Simultaneously browse data from multiple tables.
	Cache and paginate the database data
	View the data in two modes: multiple records at a time or a single record at a time
	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.
	Intuitive browse using drag&drop from the layout pane.
SQL editor	Build queries by adding tables per drag&drop, following relations and clicking columns.
	See the generated SQL text.
	Set WHERE filters over particular columns.
	Use of INNER JOIN; OUTER JOIN and EXISTS join conditions
	Use Group By and aggregate functions.
	Execute the generated Query.
	Execute the generated Query.
	Print the generated diagram.
	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
	Save the query result directly to a file. This is useful if the result is large
Database synchronization	Synchronize local schema with the 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 ( this is synchronization with a different project file, useful for team work )
	Convert the project to a different RDBMS
	Generates SQL schema creation scripts for any database
Documentation	Easily document and comment tables, columns, foreign keys, indexes, etc.
	Generates schema specification as an HTML/XHTML document.
	Print schema Layouts with precise control
	Generates schema Layout image files, in a few formats (PNG [raster] or SVG [vectorial])
	Interactive documentation file images, with tool tips over the columns and tables.
	Small, compact documentation files due the vectorial images. Easy to deploy in web.
	Create, edit, and maintain database templates.