How to Manage Address Migration

You must perform the following tasks to migrate address data:

• Before upgrading the database, you must run a script to identify records that have the same ROW_ID between S_ADDR_PER and S_ADDR_ORG. You must eliminate duplicate row IDs.

• You must evaluate whether to modify upgrade scripts to migrate address data in custom extension columns in S_ADDR_PER and S_ADDR_ORG. Review the new schema and determine whether your custom columns can be mapped to standard columns. If no matching standard columns exist, then create new columns on the target tables. During the database upgrep, you do this after running the Database Configuration Utilities but before running the Upgrade Wizard.

• After the upgrade is complete, review the records in S_ADDR_PER and eliminate duplicate and obsolete records.

To manage address migration, follow the steps in Process of Upgrading a Siebel Test Environment. Each of the address migration tasks is included as a step in this process. Each step refers you to a procedure for performing the task.