Context Database Designer 3.36 Build

A sturdy and comprehensive database management tool that helps you create detailed schema for your queries, tables, relations and procedures
Context Database Designer provides the full cycle of database schema design and maintenance, including: creating of tables, relations views and stored procedures; drawing of sophisticated and professional looking diagrams; maintaining the history of changes made to the database schema; allows to compare any two versions of any two schemas, view the difference and instantly build upgrade SQL script for any given database engine.

Context Database Designer can help you build detailed database schema for all the data it includes, ranging from tables to queries.

Context Database Designer does what very few professional and expensive tools can - it is able to automatically generate create/alter/drop DDL scripts for virtually any database engine.

Context Database Designer is also able to import SQL DDL scripts for any database engine, which is accomplished by highly customizable SQL generator/parser - a unique piece of software, developed by Contexts Software.

The only thing required in order to support another database engine is to create a simple text profile (see them stored under 'dbdefs' folder), defining a way to input and output SQL scripts for that particular type of database.

Main features:

  • Diagramming features:
  • Professional looking diagram view with several ways of displaying fields and relations;
  • Virtually unlimited Undo/Redo stack;
  • Smart connectors handling;
  • Multi-selection;
  • Copy/paste, including pasting as enhanced metafile to any text editor, like Word, for documenting;
  • Simple HTML markup in text labels;
  • Multiple diagrams can be created for the same schema;
  • Automatically laying out large diagrams into smaller pages for printing, (with account for gutter) with ability to select which pages to print;
  • Drag & drop tables and relations from schema tree view;
  • Draw tables and relations directly on a diagram;
  • Stored diagrams and schema within one file;
  • Import/Export diagram and schema from/to XML.
  • Schema related features:
  • Supports many types of schema objects, like: tables, indexes, views, triggers, stored procedures/functions, domains, sequences/generators;
  • Maintains history of changes done to schema via Checkpoints;
  • Allows to revert to any checkpoint, compare checkpoints and drop/purge old checkpoints to save disk space;
  • Automatically creates SQL scripts, that updates database from one version to the next;
  • Supports custom (user defined & engine specific) fields, with ability to customize their property editors (validation and lookups);
  • Generates any type of SQL scripts from completely custom database profile (stored as *.dbp file under 'dbdefs' folder);
  • Compensates for luck of DDL features in some engines (like inbility to rename a field or a table) by automatically generating more complex scripts, involving recreating & copying tables;
  • Powerfull comparison tool, allows to compare any two versions of any two schemas, show every property, that differs and instantly automatically creates SQL upgrade script for any engine;
  • Imports schema from sql database creation scripts, including importing of CREATE/ALTER and DROP statements, domains, stored procedures and functions, triggers, constraints, indexes, etc.;
  • Uses same profile for import and export of SQL. This allows fine-tuning of import/export features.
  • Allows to execute any SQL command towards any of registered databases. As a standalone application, Context Database Designer supports BDE & ODBC database access. When run from IDE, it can support any database via DBX, ADO or Interbase access objects and also custom databases, like DBISAM & Nexus;
  • Registers as a component editor for TDatabaseSchema component from our Database Extensions Suite, which puts all this power right under developers fingertips.
  • Generate schema documentation (as html files or chm help) based on customizable templates.

last updated on:
September 24th, 2014, 7:00 GMT
file size:
3.1 MB
developed by:
Michael Baytalsky
license type:
operating system(s):
Windows All
C: \ Internet \ Servers \ Database Utils

In a hurry? Add it to your Download Basket!

user rating



Rate it!
13 Screenshots
Context Database Designer - The application allows you to easily design and manage multiple schema for your databases.Context Database Designer - By right-clicking on the main window, you can copy table definitions or filter certain queries and fields.Context Database Designer - From the File menu, you can generate documentation for your database schema or export it as image.Context Database DesignerContext Database DesignerContext Database DesignerContext Database DesignerContext Database DesignerContext Database DesignerContext Database DesignerContext Database DesignerContext Database DesignerContext Database Designer
What's New in This Release:
  • Improvements:
  • #907. Added support for RAD Studio XE 7 to Database Extensions
read full changelog

Add your review!