ANN: Context Database Designer & Extensions v.2.11 is now available!

Dear Friends,

We are happy to announce the new release of Context Database
Designer & Database Extensions v.2.11.

Context Database Designer & Extensions now supports:
- MS SQL 2000/2005/Express
- MS Access
- Interbase\Firebird (NEW!)
- My SQL 4 & 5
- Mimer 9
- Oracle 8
- DBISAM 3 & 4
- Nexus 1 & 2
- Paradox

We strongly advise all users to upgrade to this release
as it addresses some problems and adds many great features.

Improvements

#458. Added diagram export to BMP, PNG and HTML formats (see File | Export
as Picture or Web page... command). HTML export generates image map for all
tables and links.

#459. Added access to schema properties from Schema Import dialog.

#460. Added case sensitivity handling in schema consistency test.

#461. Added comprehensive support for Firebird 1.5 database. This includes:
FB\IB Database Adapter, SQL generation, SQL import and Reverse Engineering.

#462. Added incremental import of SQL script into current database schema.

#463. Added option to automatically resolve some of consistency issues (see
"Resolve this problem" context menu item in messages window).

#464. Added schema level option to enclose identifiers in double quotes or
square brackets when generating SQL (i.e. enforce delimited identifiers).

#465. Added shortcuts for Create Version Checkpoint, SQL Console and Create
or Update Database Structure.

#466. Added support for custom schema objects, which could be use to contain
objects, like IB\FB Exceptions, file groups, etc.

#467. Improved Domain Properties dialog. The program now only require
confirmation if any of the assigned domains have changed.

Issues Addressed

#468. Fixed Access Violation on testing database schema, when database
profile is not assigned.

#469. Fixed bug in Relationship Properties dialog. When automatically
creating fields the property SQLFieldType was not assigned.

#470. Fixed bug in search/replace dialog. When searching for views it was
also returning stored procedures.

#471. Fixed bug in trigger definition parsing. Parser hanged indefinitely if
it is unable to locate token 'ON'.

#472. Fixed bug with not saving Size property of a field definition object
if it is equal to 0.

#473. Fixed problem with assigning duplicate names to unnamed indexes and
constraints when importing from SQL script.

#474. Fixed problem with keeping file lock on previously edited schema
(problem occurred after creating new schema).

#475. Fixed problem with parsing/skipping single word statements, like
COMMIT.

#476. Fixed problem with printing multiple copies when collation is
supported by printer driver.

#477. Fixed problems with help not being linked to some of the dialogs.

#478. Fixed problem with unnamed constraints not being assigned default
names when importing from SQL script.


Both products are immediately available for download at:

http://www.contextsoft.com/products/dbdesign/downloads.jsp.
and
http://www.contextsoft.com/products/ctxdbext/downloads.jsp.

See screenshots here:
http://www.contextsoft.com/products/dbdesign/screenshots.jsp

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; comparing any two
versions of any two schemes, viewing the difference and instantly
building upgrade SQL script for any given database engine.

We believe, that Context Database Designer is one of the most
powerfull, flexible and feature-rich tools available on the
market today. We highly appreciate your comments and suggestions
that help us making it even better and more accessible for all
database developers.

Fully functional trial version 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.

Sincerely,
Michael Baytalsky
e-mail: mike@xxxxxxxxxxxxxxx
http://www.contextsoft.com


.

Relevant Pages

  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)
  • Split messages
    ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
    (microsoft.public.biztalk.general)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Decouple SQL queries from class in OOP design
    ... If the data is owned by the application, embedding SQL might be ... - It couples the application to the database schema. ... - The "validate employee ID" functionality is likely to be used ...
    (comp.object)