Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX > Postupgrade Tasks > Postupgrade Tasks for All Environments >
Migrating Custom Columns on Obsolete Tables
CAUTION: This procedure only applies to development environment upgrades. However, the output of this procedure is also used in the production environment.
Customer extension columns on obsolete tables need to be identified and manually migrated after the upgrade. However, Siebel columns on obsolete tables are reconfigured and migrated during the upgrade and therefore do not need to be manually migrated. Custom extension columns on tables that are upgraded (not obsolete) are also retained during the upgrade.
Critical obsolete tables are listed in Table 18. Any customer extension columns based on these tables must be manually migrated.
The
rpt_obs_tbl_custom_cols.sql
script identifies custom columns on obsolete tables and generates SQL template update statements for migrating the custom columns on obsolete tables to new tables during the upgrade.
- Part 1
Part 1 compares the Prior Standard Siebel Repository with the Prior Custom Repository and generates a report of custom columns on obsolete tables for Release 7.x that need to be manually migrated. For example, if you created custom columns on S_EMPLOYEE, S_ORG_INT, or S_EMP_POSTN, the report would contain a list of custom columns on these obsolete tables. Use the output of this section of the script to analyze and identify custom columns on obsolete tables that require manual migration. Run this portion of the script during the upgrade of your development environment. You use the information generated by this part of the script for both your development and production environment upgrades.
- Part 2
Part 2 generates SQL template update statements for migrating data from obsolete tables to new target tables. Before running these statements, carefully check that the target tables specified are accurate for your configuration. Modify the SQL template update statements as needed. After the upgrade of your development environment and production environment, run the update statements to migrate data to new tables.
To identify custom columns on obsolete tables and generate SQL template update statements
- At the odbcsql command, under the
$SIEBEL_ROOT/siebsrvr/bin
directory, invokerpt_obs_tbl_custom_cols.sql
by entering:
odbcsql /s "
$ODBCDataSource
" /u
$TableOwner
/p
$TablePassword
/separator / /a /v /c
rem
/l
$SiebelRoot
/log/rpt_obs_tbl_custom_cols.log
$DbsrvrRoot
/
$DatabasePlatform
/rpt_obs_tbl_custom_cols.sql
"$AncestorRepName"
Part one of the script compares the Prior Standard Siebel Repository with the Prior Customer Repository and generates a report that includes obsolete tables and custom columns mapped to obsolete tables. The second part of the script generates SQL template update statements that you can use to manually migrate your custom columns to new target tables.
- Review the report generated by part one of the script and identify custom columns on obsolete tables. After the upgrade, you need to remap all custom columns listed in this report to new target tables.
- Review the SQL template update statements generated by part two of the script.
Modify the SQL template update statements for your configuration. After you have modified them, you can run them after the upgrade to migrate custom columns For more information, see Running Update Statements.
NOTE: Run these update statements after you upgrade your development environment and after you upgrade your production environment.
Running Update Statements
In the development environment, you ran the script
rpt_obs_tbl_custom_cols.sql
to identify custom columns on obsolete tables and to generate SQL template update statements. You can use the SQL template update statements generated by this script to migrate data in custom columns on obsolete tables to new tables. To do this, review and edit the SQL template update statements for your configuration. For example, you should check that all target tables specified in the update statements are accurate for your configuration. After you have edited the statements, run them.
- Navigate to
$
DBSRVR_ROOT
/log/rpt_obs_tbl_custom_cols.log
to access the SQL template update statements generated byrpt_obs_tbl_custom_cols.sql.
- Edit the SQL template update statements as required for your configuration. You can use a simple text editor application to edit the statements.
- Using ODBCSQL, or any client or vendor provided interface which can execute SQL, run the update statements against the upgraded database.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX Published: 20 October 2003 |