Softpedia >Windows >Internet >Servers >Database Utils >Context Database Designer >  Changelog

Context Database Designer Changelog

What's new in Context Database Designer 3.43 Build 3.43.1.1440

Mar 14, 2018
  • Issues Addressed:
  • #944. Fixed bug with restoring schema editor layout.
  • #945. Fixed bug in DBISAM profile - setting encrypted table property.
  • #946. Fixed bug in drag & drop operations with database connection.
  • #948. Auto size sequence column in fields editor (there was a problem when the number of fields exceeded 99).
  • Improvements:
  • #947. Added option "Cursor beyond EOL" to the SQL editor.

New in Context Database Designer 3.38 Build 3.38.1.1418 (May 20, 2015)

  • Issues Addressed:
  • 922. Fixed bugs in SQL parser. Now it allows to use / as a delimiter (could be used in Oracle).
  • 923. Fixed bugs in CSV parser in Data Import tool.
  • Improvements:
  • 924. Added support for views in MySQL 5 database profile.
  • 925. Added create or replace to Oracle profile.
  • 926. Added support for RAD Studio XE 8.

New in Context Database Designer 3.37 Build 3.37.1.1417 (Dec 24, 2014)

  • Issues Addressed:
  • Fixed minor bug when reverse engineering character length for unicode databases in Oracle profile.
  • Fixed bug with copy and select all commands not working in the SQL Console Log.
  • Fixed bug with slow unchecking of all objects in the reverse engineering view due to relationships checking.
  • Fixed minor issues in the MySQL 5 profile.
  • Fixed bug in tree view search for database objects.
  • Improvements:
  • Auto save schema (dsd file) before SQL generation and checkpoint creation.
  • Change detection for XML or DSD file. Confirming when overriding a file modified outside of the designer.
  • Added IgnoreDupKey option to MSSQL profile for Primary key and Unique constraints.

New in Context Database Designer 3.36 Build 3.36.1.1416 (Sep 24, 2014)

  • Improvements:
  • #907. Added support for RAD Studio XE 7 to Database Extensions

New in Context Database Designer 3.35 Build 3.35.1.1416 (Sep 23, 2014)

  • Issues Addressed:
  • #903. Fixed several bugs in Data Import tool
  • Improvements:
  • #904. Data Import tool improvements include: automatic data size calculation for VARCHAR fields, required fields and value length checked during import
  • #905. Data Import now allows to specify the width in characters of output SQL file

New in Context Database Designer 3.33 Build 3.33.1.1407 (Apr 29, 2014)

  • Improvements:
  • Added option to autosave schema after checkpoint creation.

New in Context Database Designer 3.32 (Apr 29, 2014)

  • Improvements:
  • Added support for Delphi XE3 and XE4 to Database Extensions.

New in Context Database Designer 3.31 (Apr 29, 2014)

  • Issues Addressed:
  • Fixed problem with MS SQL altering of columns that are part of indexes (indexes needs to be dropped and recreated).
  • Fixed minor bug in Nexus data adapter.
  • Fixed minor bug in Query Expression editor.
  • Fixed several minor bugs.
  • Improvements:
  • Added ability to filter tabled based on currently selected diagram in the Copy Table Definitions dialog.
  • View object on a diagram now shows SQL statement if the fields are not defined. In case fields are defined, the statement is shown in hint.
  • Added ability to allow blob indexing on some database engines (SQLite Text type for example).

New in Context Database Designer 3.30 (Apr 29, 2014)

  • Issues Addressed:
  • Fixed problem with MSSQL varchar(max).
  • Fixed bug foreign key constraint names in MSSQL reverse engineering.
  • Fixed access violation when copying table structure from one schema to the other.
  • Improvements:
  • Added support for MSSQL 2008 (database profile).
  • Database Designer no longer locks the diagram (dsd) file while working.
  • Added warning when sorting Stored Procedures alphabetically to prevent mixing them up in the generated script.
  • Added schema consistency check for Set Null constraints applied to NOT NULL columns.
  • Added schema consistency check for Set Default constraints applied to columns with no DEFAULT constraint.
  • Added ability to drug and drop Relations and Relationships nodes to the diagram. In case of Relations node, it will add all of the table's relations to the diagram. In case of Relationships node, it will add all the relations between all the tables already on a diagram page.
  • Added command to the diagram table's right mouse menu to add all relationships. This command work for individual tables as well as any selected set of tables on a diagram page.

New in Context Database Designer 3.29 (Apr 29, 2014)

  • Issues Addressed:
  • Fixed bug when reverse engineering primary keys in Oracle. Not all PKs were imported.
  • Fixed bug when reverse engineering primary keys in Oracle. Not all PKs were imported.
  • Fixed bug with specifying a custom zoom % in diagramming.
  • Fixed bug with key not working in lookup editor popup windows.
  • Fixed bug with right click select not working in SchemaTreeView.
  • Fixed bug with Refresh operation does not work in the *Drop* SQL Script window.
  • Fixed hot key collision in the "Find Text" dialog.
  • Fixed bug with connection string builder dialog producing a wrong string. It now allows to edit the connection string.
  • Fixed bug with Project Group always being modified once opened.
  • Improvements
  • Added list of keywords that raise error when found in field names.
  • Added properties for TRelation object to Schema Import & Comparison windows.
  • Added IgnoreSpaces & CaseInsensitive options to Schema Comparison.
  • Added handling for Default Database (showing in window caption, select in toolbar popup).
  • Added feature to remember file names under which a particular script has been stored to disk from SQL Editor Window. When saved again, the editor will save under the remembered file name. Hold to save under different file name.

New in Context Database Designer 3.28 (Apr 29, 2014)

  • Issues Addressed:
  • Fixed bug in reverse engineering of Primary Keys in Oracle. Not all PKs were imported.
  • Fixed bug in ElevateDB profile - generating invalid drop index script.
  • Improvements:
  • NEW FEATURE! Added Project Group feature allowing to manage a collection of database schemes as a whole.
  • Added warning when an object name is equal to SQL keyword.
  • Added relation properties to the object inspector in Schema Import and Schema Comparison windows.
  • Added CaseInsnsitive and IgnoreSpaces options to Schema Comparison.

New in Context Database Designer 3.27 (Apr 29, 2014)

  • Issues Addressed:
  • Fixed bug with creating a NoCase index in DBISAM 4.
  • Fixed bug with generating foreign keys to "external" tables.
  • Fixed import of INTEGER fields in Oracle profile.
  • Improvements:
  • Added ASSERT pragma to SQL scripts. Usage: -- ## ASSERT: . This pragma will raise error if select statement is invalid or returns empty or zero value.
  • Added ability to turn on/off line number in SQL editor.
  • Added popup menu item command in SQL editor to insert script header.
  • Added option to change font size in the script editors.
  • Added word wrap of the text in the execution log.

New in Context Database Designer 3.26.1.1275 (Oct 3, 2011)

  • Issues Addressed:
  • #835. Fixed bug with creation, dropping and altering relationships when any of the related tables/views have ProduceSQL = False.
  • #836. Fixed importing of index field names in EDB2 database profile.
  • #837. Fixed generation of ALTER COLUMN statements in EDB2 database profile.
  • Improvements:
  • #838. Added object assist and syntax hightlight for relationship names in SQL editors.
  • #839. Add "External" (True/False) flag for tables and views objects. SQL is not produced for the external objects, however, the foreign keys pointing TO them are generated.
  • #840. Added ability (optional) to specify port in the Nexus 3 server connection (format: server_name[:port]/database).