Context Database Designer is a great tool for designing and managing database schemas. It 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 does what very few professional and very expensive tools can - it is able to automatically generate create/alter/drop DDL scripts for virtually any database engine.
Moreover, it also is 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.
-Maintains history of changes by storing version 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); more
Comments