Upgrade Guide and New Features

This section describes the differences between versions of Dovetail SchemaEditor.

Version 2.3.3

Added an option for Oracle users to change how removing columns works. See oracleDropColumnStrategy for more details.

Additionally, extra validation has been added around column drops and modifications:

• SchemaEditor will no longer fail when a column is being removed from the schema but has already been manually removed from the database.
• On Sql Server, when a column being removed from the schema is involved in one or more database indexes. The preview or apply operation will fail and report the indexes to which the affected columns belong.
• On Oracle, when a column being modified (length, or decimal precision) is involved in one or more functional database indexes. The preview or apply operation will fail and report the functional indexes present affecting the change.

Fixed an Oracle SQL statement ordering bug when modifying a non searchable column to be searchable.

Version 2.3.2

Bug Fixes:

On Oracle changing the width of a table column that is searchable is now updating the width of both base column and "s_" columns.

Oracle 8 has had two issues corrected which were preventing it from working correctly.

• SQL inserts and updates of text fields could fail due to data typing issue.
• Creation of tables and views were emitting DDL which was unsupported by Oracle 8.

Objid generation for ADP tables was occurring when it was not necessary. Objid generation for ADP tables will now only be done when the database being modified is Amdocs 6 (or higher).

Version 2.3.1

Installer now enforces required versions of the Microsoft .Net framework. Requires either: 3.5 SP1, or .Net 4.0 Full framework versions.

Bug Fix:

Resolved an intermittent issue with the order in which schema changes were being applied.

Version 2.3

Added configuration setting for Oracle 11.

Added support for ignoring problematic database views via configuration using the ignoreViews Object.

Version 2.2.1

Bug Fix:

Indexes can now be added or updated when using an indexed column/relation name where the casing of the field name(s) does not match the casing of the field definition on the table.

Version 2.2

Added more context to error messages that appear when schema differences are invalid. This should make it easier to find the troubled bit of schema when certain difference validations fail.

Fixed a data access bug which could occur in certain scenarios when adding a column to an table which was also being updated.

When creating table fields in Oracle the Long Text field now defaults to the CLOB data type when they are supported by the database.

Database access support libraries have been updated.

• Added configuration setting for Microsoft SqlServer 2008.

Version 2.1

To correct instances where the database schema does not match the Clarify schema, DDL will be emitted when dropping Tables, Views, Indexes, and Synonyms (Oracle), only if they exist in the database schema.

Fixed a bug introduced in 2.0 where Dovetail SchemaEditor could only be run from the install directory.

Added a logging appender, which during a preview action, receives the SQL statements that would be used during an apply operation. These statements are intended to be informational and not executed by a database administrator.

Version 2.0

This major release adds support for schema meta-data changes introduced in versions of Amdocs 6 and higher.

Dovetail SchemaEditor now requires version 3.5 of the .Net framework.

Database Specific SQL for SQL Views

Customers utilizing Amdocs 6 and later versions of the database can now specify SQL for sql views that targets a specific database provider. This new functionality is exposed to Data Dictionary XML as the databaseSpecificSql element. Likewise when using Schema Script addSqlView or updateSqlView commands sql elements can specify a target database.

File Formats updated to support new Amdocs 6 functionality

To support new functionality in Amdocs 6 and newer databases, we have updated the namespace of the XML documents used to apply schema changes. Data Dictionary and Schema Script XML documents have new namespaces and matching .xsd files for validation. Dovetail SchemaEditor will still work with old versions of the Schema Script and Data Dictionary XML documents. However, users targeting Amdocs 6 or newer databases will need to use the new file formats to take advantage of new features. For more details please see Schema Script Namespaces or Data Dictionary Namespaces.

Bug Fixes

• Corrected a bug where SQL Views with base tables could be created incorrectly depending on the order of the view columns.

Version 1.5.1

Corrected a bug where it was possible using Schema Script to add duplicate join's to a view. This would cause an error when applying schema changes to the database.

Version 1.5

Requirement Change:

• SchemaEditor now requires .Net 2.0 with Service Pack 1.

Bug Fix:

• Corrected a validation bug that occurred when running against Oracle databases where an existing many to many association table was close to exceeding the Oracle 30 character limit on table names.
• To be compatible with Clarify applications, we have corrected a class of problems related to the ordering of objects in the Clarify schema metadata.
  • Removing a column from a table requires that the remaining columns on the table have their orders (spec_rel_id) updated to be contiguous.
  • Removing a view column from a view requires that the remaining view columns on the view have their orders (spec_rel_id) updated to be contiguous.
  • Removing a relation from a its tables require that the remaining relations on those tables have their orders (spec_rel_id) updated to be contiguous.

    Note: When re-ordering a many to many relation the 'mtm_' association table will be renamed to follow the Clarify convention.

  • A view column referencing a user defined column cannot be ordered before view columns referencing predefined fields. When this occurs the 'user defined' view columns will be moved to the end of the view column ordering.

To upgrade to this release:

• Uninstall the existing version of Dovetail SchemaEditor
  Start - Programs - Dovetail Software - Dovetail SchemaEditor - Uninstall Dovetail SchemaEditor
• Install the new version of Dovetail SchemaEditor using the supplied Microsoft Installer (MSI)

Version 1.4.5

Bug Fix:

• Fixed a bug in ManyToManyRelationDdlGenerator where Grant statements were not being created for the many to many association table.

Version 1.4

Enhancement:

• Adds generation of stored procedures for views and sqlviews to achieve better compatibility with early versions of Clarify Classic Client.

Version 1.3

Enhancement:

• Adds generation of stored procedures for tables and relations to achieve better compatibility with early versions of Clarify Classic Client.

Bug Fix:

• For better compatibility with Clarify's tools, SchemaEditor no longer sets the isSearchable field for columns when applying schemas to MS SQL Server. For more information, see our knowledge base solution.
• StorageLocation was not working when applying Schema Script.

Version 1.2

This release adds support for SQL views. View the SQL Views section for more details.
In addition, the performance of schema scripting has been improved. The load on the database and the network during schema script processing has been reduced.

Data Dictionary XML changes:

• sqlView and sqlViewColumn elements are now supported.

Schema Script XML changes:

• alias has been added as an optional child element of updateViewColumn.
• addSqlView, addSqlViewColumn, updateSqlView, and updateSqlViewColumn elements are now supported.

Bug Fixes:

• Better handling of views with implicit cross joins
• Fixed a problem in the ordering of objects, which could cause viewColumns to have the the same spec_rel_ids, and could also cause joins to have the wrong spec_rel_id for their relation
• Fixed a problem with metadata (ADP) generation of joins when the relation went to and from the same table

Version 1.1

This release adds support for schema scripting. This allows users to simply script only the changes to be made to the schema, as opposed to representing the entire schema. View the Working with Schema Script section for more details.

This release also adds support for Microsoft SQL Server 2005 databases.

Data Dictionary XML changes:

• The kind attribute on the join object has been simplified. Previously, there were three join kinds: Inner, Left, and Right. Now, there are only two: Inner and Outer. Refer to the join reference for additional details and examples.
• The OneToOnePrimary type attribute on the relation object has been changed to OneToOne.
• The xmlns attribute on the schema object has been updated to account for the above listed changes to the XML.

.SchemaEditor file changes:

• The schemaFilePath element has been renamed to inputFilePath.
• An exportFilePath element has been added.
• The xmlns attribute on the schema object has been updated to account for the changes to the inputFilePath attribute.

Bug Fixes:

• New OneToOne relations were being added with the wrong cardinality to the metadata (ADP) tables. A OTOP was being added to the adp_sch_rel_info table as OTOF, and OTOF's were being added as OTOP. Notice that it was backwards. If you added a new OneToOne relation with version 1.0, please contact Dovetail Software for details on how to correct this issue. This issue has been fixed in version 1.1.

Version 1.0

Initial Release

Did this topic help you? Email us your feedback.
Last updated: 3/23/2009 9:39:15 AM
© by Dovetail Software, Inc.