Configuring Siebel eBusiness Applications > Configuring Tables and Columns >

Applying Data Model Changes to the Server Database

After applying data model changes to your local database, testing them, and then checking the projects back in to the server database, you need to apply the changes to the physical server database. Until you do so, only the logical database schema of the server database has been updated.

You can apply data model changes using Siebel Tools or using the Database Configuration Utility.

To apply and activate the changes to the server database Using Siebel Tools

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.

   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.

   The Apply Schema dialog box appears.

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

   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 Propagating Changes to Other Local Databases.

6. Restart the Siebel Server.

   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.

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