REQUEST A DEMO

Tag: updating existing schema

Authoring Schema Script to ‘Upsert’ changes to your database. (a.k.a Add and/or Update)

May 17, 2010 Authoring Schema ScriptThis post will teach you the best way to author your Schema Editor schema script to do upserts, adds and/or updates to your Amdocs database schema. Luckily, you do not often have to worry about doing upserts but there is one situation where not doing them can get you into trouble.Anytime you provide schema script which should work whether the object exists or not and must change properties of the original.Sorry if that just lost you. Let's start out with the basics. What is this Schema Script?We created Schema Editor for Amdocs users who need a better way to update the database schema of their Clarify/Amdocs database. When we created SchemaEditor, Gary Sherman was adamant that we needed a new workflow for updating the schema. The classic workflow involved exporting the database schema, manually editing the result, and reapplying the changes. It is not…