Schema Script Namespaces

To avoid breaking compatibility for customers that have not upgraded to an Amdocs 6 databases, we have introduced a new Schema Script document namespace and accompanying .xsd file used for validation. This new Schema Script file format will contain the additional database schema features introduced by Amdocs 6.

Backwards Compatiblity

Existing Dovetail SchemaEditor customers should have no problem using their existing Schema Script documents with Dovetail SchemaEditor.

To avoid ambiguity, we chose to not allow use of the new Amdocs 6 compatible schema with pre Amdocs 6 databases. Schema Scripts created with Amdocs 6 specific elements will not be usable on non Amdocs 6 databases. However, it is quite easy to manually remove the Amdocs 6 specific tags and change the namespace of the document.

Schema Script Example Documents

Below are examples of Schema Script documents of each file format. The differences are emphasized.

Pre Amdocs 6 Schema Script

<schemaScript xmlns="http://www.dovetailsoftware.com/2006/10/SchemaScript.xsd">

   <addSqlView name="my_new_SQL_view" id="4040">

    <description>my SQL view description</description>

    <sql>select title from table_case</sql>

   </addSqlView>

   <addSqlViewColumn name="owner" sqlView="my_new_SQL_view" datatype="String" >

    <length>40</length>

    <description>description for sql view column</description>

   </addSqlViewColumn>

</schemaScript>

Amdocs 6 or later Schema Script

<schemaScript xmlns="http://www.dovetailsoftware.com/2009/03/SchemaScript.xsd">

   <addSqlView name="my_new_SQL_view" id="4040">

    <description>my SQL view description</description>

    <sql>select title from table_case</sql>

    <sql targetDatabase="mssql">select title from table_case</sql>

   </addSqlView>

   <addSqlViewColumn name="owner" sqlView="my_new_SQL_view" datatype="String" >

    <length>40</length>

    <description>description for sql view column</description>

   </addSqlViewColumn>

</schemaScript>

Upgrading to Amdocs 6

Users of Dovetail SchemaEditor version who have upgraded to Amdocs 6 should update the namespace of their Schema Script documents to match the Amdocs 6 example. In particular, the xmlns attribute on the root schemaScript element should be:

http://www.dovetailsoftware.com/2009/03/SchemaScript.xsd

Did this topic help you? Email us your feedback.
Last updated: 4/15/2009 4:27:52 PM
© by Dovetail Software, Inc.