Siebel Data Warehouse Installation and Administration Guide > Upgrading Siebel Data Warehouse > Upgrade Requirements for Siebel Data Warehouse 7.7 >

Approaches to Upgrading the Siebel Data Warehouse

There are two approaches to upgrading Siebel Data Warehouse, upgrading with Data Warehouse migration and upgrading without Data Warehouse migration.

Upgrade with Data Warehouse data migration. In this approach all the existing data in the Data Warehouse is upgraded using the 7.7 upgrade processes. The advantages of this approach are that you retain all your historical data, such as slowly changing dimension, pipeline, and so on. This process is faster than reloading the entire data again. To implement this kind of upgrade, see the procedures in Transactional Database Environment (Analytics-Specific) Upgrade, and Data Migration Workflows for Siebel Data Warehouse Data Upgrades.

Upgrade without Data Warehouse data migration. In this approach all the data from the transactional database is reloaded again into the Data Warehouse (Full Load) using the 7.7 repository. The advantages of this approach are that you retain all the bug fixes, and the data is consistent. The disadvantages to this approach are that you would loose historical data like slowly changing dimension, pipeline, and so on. This process takes a longer time to complete than upgrading with data migration. To implement this kind of upgrade follow procedures listed in Process of Siebel Data Warehouse Upgrade, Data Migration Workflows for Siebel Data Warehouse Data Upgrades, and Running Data Migration Workflow for Preconfigured Content in Siebel Data Warehouse. After completing these procedures, run a full load from DAC.