SchemaEditor

Dovetail SchemaEditor allows the database schema to be modified and extended to enable additional features and customizations. By simplifying schema changes, optimizing database transactions, and eliminating unnecessary database changes, Dovetail SchemaEditor has proven itself to be the most efficient schema tool for Clarify available. Customers have reported 10x speed improvements in schema changes by using Dovetail SchemaEditor instead of Clarify ddcomp or Amdocs SchemaManager.

SchemaScript

SchemaScript provides a simple way of specifying changes to a database schema. In most instances, changes are made to the schema in an incremental fashion with each iteration applying only one or a few changes at a time. Rather than working with the entire schema in a file (which can easily run into hundreds of thousands of lines), SchemaScript allows just the changes to be defined.

 


 

Features

  • Creates, modifies, and delete database objects (tables, views, columns, relations, joins, indexes).
  • Performs the same changes to the database (both to the actual database tables as well as to the ADP metadata tables) as ddcomp/SchemaManager.
  • Dramatically improves performance compared to ddcomp or SchemaManager.
  • Uses standard XML files for defining the schema and schema changes.
  • Ships with XML Schema Definition (XSD) files, so that you can use industry standard tools to modify and validate schema files, and be confident that the XML is valid.
  • Supports SchemaScript, which is a simple, imperative way of specifying the changes to be made to the database schema.

 

 


 

SchemaScript

SchemaEditor supports SchemaScript, which is a simple way of specifying changes to a database schema. In most instances, changes are made to the schema in an incremental fashion with each iteration applying only one or a few changes at a time. Rather than working with the entire schema in a file (which can easily run into hundreds of thousands of lines), SchemaScript allows just the changes to be defined.

 


 

I want to thank Gary of Dovetail for expeditiously examining the problem and providing a quick resolution.

Andrew Szendey, Programs Manager | BMS, Global Customer Care

 


 

Related Resources

International: +1 (512) 610-5400
Toll Free: 1 (800) 684-2055