Applying schema changes to local and server databases

All additions and modifications to data layer object types such as tables, columns, indexes, and user keys must become manifest in the physical database.

To accomplish this, Oracle provides two utilities, which we will discuss in this section:

  • Siebel Tools Apply feature
  • Synchronize Schema Definition process (ddlsync)

The Siebel Tools Apply feature is typically used by developers against their local databases but it also works against server databases.

The Synchronize Schema Definition process is intended for use against server databases and helps in automating the synchronization of the Siebel Repository metadata information against a physical database.

Using the Siebel Tools "Apply" feature

The following ...

Get Oracle Siebel CRM 8 Developer's Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.