ANN: Context Database Designer & Extensions v.2.03 are now available!
- From: Michael Baytalsky <mike@xxxxxxxxxxxxxxx>
- Date: Wed, 12 Apr 2006 21:45:55 +0300
Dear Friends,
45 years ago, today, the first man flew into space! We
are celebrating this greatest achievement of humankind
by releasing the first final version of Context
Database Designer & Database Extensions v.2.03. :)
It is immediately available for download at:
http://www.contextsoft.com/products/dbdesign/downloads.jsp.
and
http://www.contextsoft.com/products/ctxdbext/downloads.jsp.
Great screenshots are availble at:
http://www.contextsoft.com/products/dbdesign/screenshots.jsp
We strongly advise all beta users to upgrade to this release
as it addresses many problems and adds many great features,
including:
- Added support for Delphi 2006;
- Added support for Oracle and Nexus 2;
- Improved support for MS SQL Server 2000/2005;
- Improved schema consistency testing, added more
warnings and errors related to foreign key
constraints, type mismatches and more;
- Greatly improved SQL import function;
- Reverse Engineering is coupled with import and
improved to allow partial reverse engineering;
- Import functionality now allows to partially
override schema objects, which is handled
correctly by SQL generator;
- Added automatic handling of auto-incremental or
identity fields when generating DML statements
(e.g. when a table needs to be recreated
preserving the data);
- Add IDEF1X & UML notations to diagram;
- Fields display engine-specific data types and
only allow to select data types, supported by the
target database engine;
- Added popup dialogs for editing long script
properties, like Check constraints and
Description;
- SQL generation improved to allow deletion and
smart recreation of all affected foreign key
constraints. This is particularly important for
engines, not supporting CASCADE deletion of
tables, like MS SQL;
- Added custom connections parameters including
UserName and Password for all database adapters;
- Added correct, engine specific, syntax
highlighting everywhere where SQL text occurs;
- Improved adapters loading. Context Database
Designer no longer loads adapters on startup, but
only when they're required to establish database
connection, which significantly improves startup
time;
- Added Options dialog; Adapters page allows to
add and remove database adapter libraries;
- Added data adapter for Nexus 2;
- Added Drop Database SQL generation (especially
useful for databases, like MS SQL, that do not
support CASCADE delete);
- Updated context sensitive help.
General Information About Context Database Designer
===================================================
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
expensive tools can - it is able to automatically generate
create/alter/drop DDL scripts for virtually any database engine.
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.
The main diagramming features of Context Database Designer are:
- Professional looking diagram view with several ways of
displaying fields and relations;
- Virtually unlimited Undo/Redo stack;
- Smart connectors handling, tracking links intersections;
- 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.
The main schema related features of Context Database Designer are:
- 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.
We believe, that these features make Context Database Designer one of
the most powerfull, flexible and feature-rich tools available on the
market today. We highly appreciate your comments and suggestions that
will enable us to make it even better and more accessible for all
database developers.
Fully functional trial version (with part of source
code included) is available at:
Context Database Designer
http://www.contextsoft.com/products/dbdesign/downloads.jsp
Context Database Extensions
http://www.contextsoft.com/products/ctxdbext/downloads.jsp
For more details, please go to
http://www.contextsoft.com/products/dbdesign
http://www.contextsoft.com/products/ctxdbext
and refer to the included help files, demos and screenshots.
Best regards,
Michael Baytalsky
e-mail: mike@xxxxxxxxxxxxxxx
http://www.contextsoft.com
.
- Prev by Date: Re: execute internal dos commands
- Next by Date: Re: EXECryptor software protection
- Previous by thread: Firefox js parser
- Next by thread: Re: Wizard component - opinions needed
- Index(es):
Relevant Pages
|
