Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 10 total
Thread ANN: Context Database Designer & Extensions v.2.03 are now available!
Wed, Apr 12 2006 2:42 PMPermanent Link

Michael Baytalsky
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. Smile

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:

- Improved support for MS SQL Server 2000/2005;

- Added support for Oracle and Nexus 2;

- 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@contextsoft.com
http://www.contextsoft.com
Wed, Apr 12 2006 4:45 PMPermanent Link

"David Farrell-Garcia"
Michael Baytalsky wrote:

> 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. Smile
>
> 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:
>
> - Improved support for MS SQL Server 2000/2005;
>
> - Added support for Oracle and Nexus 2;
>
> - 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
Congrats Michael.  It looks great so far.  Wow!  you did a lot of work
between 2.02 to 2.03.
Wed, Apr 12 2006 4:48 PMPermanent Link

"David Farrell-Garcia"
Contrats Michael. Wow! You did a lot of work between 2.02 and 2.03.  It
looks great.
Wed, Apr 12 2006 5:59 PMPermanent Link

Michael Baytalsky

> Contrats Michael. Wow! You did a lot of work between 2.02 and 2.03.  It
> looks great.
Thanks, that's why it took so long Wink There's more to come... shortly...

Regards,
Michael
Thu, May 4 2006 3:58 PMPermanent Link

"B Miller"
Is your site down?

Bill

Thu, May 4 2006 5:45 PMPermanent Link

Michael Baytalsky


> Is your site down?
Hm, works fine for me right now.


Michael
Thu, May 4 2006 7:27 PMPermanent Link

"Gavin Horne"
Hi Michael,

I went to your site yesterday & it was extremely slow, running fine today.

Cheers,
Gavin Horne
www.hornesoftware.com.au

"Michael Baytalsky" <mike@contextsoft.com> wrote in message
news:8D81A923-7626-49EE-9A5D-7FD8CDDE43B3@news.elevatesoft.com...
>
>
>> Is your site down?
> Hm, works fine for me right now.
>
>
> Michael

Fri, May 5 2006 12:43 AMPermanent Link

Michael Baytalsky
Hi Gavin,

> I went to your site yesterday & it was extremely slow, running fine today.
Yes, I experienced the slowdown too yesterday... What can I say,
gotta change the hosting company, they suck tremendously and I'm
tired of fighting them ;(. It's just that there are so many projects
and so little time, I hate wasting days reconfiguring everything
on the new server.

Regards,
Michael
Fri, May 5 2006 8:34 AMPermanent Link

"Ralf Mimoun"
Michael,

Michael Baytalsky wrote:
....
> It's just that there are so many projects
> and so little time, I hate wasting days reconfiguring everything
> on the new server.

I have a student for these lower services Smile

Ralf
Fri, May 5 2006 3:07 PMPermanent Link

"B Miller"
I was finally able to get what I needed later in the afternoon.

Bill

"Michael Baytalsky" <mike@contextsoft.com> wrote in message
news:8D81A923-7626-49EE-9A5D-7FD8CDDE43B3@news.elevatesoft.com...
>
>
>> Is your site down?
> Hm, works fine for me right now.
>
>
> Michael

Image