Siebel Tools Reference > Adding Custom Extensions to the Data Model > Applying the Changes to the Server Database >

Applying Schema Changes Using Siebel Tools

Use the Apply dialog to apply schema changes to the server database.

To apply and activate the changes to the server database

  1. Connect to the server.
  2. In the Object Explorer, select the table from which you want to apply changes to the database.
  3. Click Apply in the Object List Editor.

    4. A dialog box appears, alerting you that you are about to connect to a local database and asking if you want to continue.

  4. Click OK.

    5. The Apply Schema dialog box appears.

  5. Fill in the fields as shown in the following table, and then click Apply.

    6. Field
    Description
    Tables
    Select one of the following options from the drop-down menu:
    • All. Update the database to reflect all changes made to the dictionary. This option forces each database object to be compared with the data dictionary, and updated if required.
    • Current Query. Update the database to reflect modifications made to the tables in the current query only.
    • Current Row. Update the database to reflect modifications made to the table in the current row only.
    Table space
    Leave blank.
    16K table space
    Leave blank.
    32K table space
    Leave blank.
    Index space
    Leave blank.
    Table groupings file
    Optional.
    This file is provided by the DBA and is specific to your database.
    Privileged user id
    Enter your database user ID, for example SADMIN.
    The table owner is read from tools.cfg.
    Privileged user password
    Enter your database user password, for example SADMIN.
    When the database initialization for a mobile client is performed, the table owner changes from SIEBEL to the mobile user's password. In this case, use the mobile user's password in the password field.
    ODBC data source
    Verify that the ODBC connection specified in the ODBC Data Source text box is correct for your environment.
    You cannot apply schema changes to any database other than the one you are currently connected to (for example, by specifying the ODBC name of a different database).

    NOTE:  If you receive an error message and cannot apply changes to the server database, you must use the Database Server Configuration Utility. See Applying Schema Changes Using the Configuration Utility.

  6. Restart the Siebel Server.

    7. Your extension tables and columns are now available to use in your configuration.

  7. Click Activate in the Object List Editor. This increases the custom database schema version and thus prepares for the mobile client upgrade.

    8. Once this process has been completed, any extensions included in the tables you selected will now physically exist on your server database.


 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003