![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Third Party Announcements » View Thread |
Messages 1 to 10 of 10 total |
![]() |
Wed, Apr 12 2006 2:42 PM | Permanent 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. ![]() 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 PM | Permanent 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. ![]() > > 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 PM | Permanent 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 PM | Permanent 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 ![]() Regards, Michael |
Thu, May 4 2006 3:58 PM | Permanent Link |
"B Miller" | Is your site down?
Bill |
Thu, May 4 2006 5:45 PM | Permanent Link |
Michael Baytalsky | > Is your site down? Hm, works fine for me right now. Michael |
Thu, May 4 2006 7:27 PM | Permanent 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 AM | Permanent 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 AM | Permanent 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 ![]() Ralf |
Fri, May 5 2006 3:07 PM | Permanent 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |