WebSphere Commerce Version 8.0.1.0 or later

Restoring the WebSphere Commerce Version 7.0 staging database to WebSphere Commerce Version 8.0

While you prepared your WebSphere Commerce Version 7.0 staging environment for migration, you backed up your version 7.0 staging database. Restore your WebSphere Commerce Version 7.0 staging database backup to your WebSphere Commerce version 8.0 staging environment. By restoring your version 7.0 database to your version 8.0 environment, you are replacing the database that was created during the version 8.0 instance creation process.

Before you begin

  1. OracleOn your version 7.0 database, run the following command:
    drop user vcw_instance_name cascade;
  2. If you are migrating the WebSphere Commerce database from one system (source) to another system (target), copy the source database backup to the target environment, and then restore it to the target database.

Procedure

  1. Drop the database that was created during the version 8.0 instance creation process. Unless you specified otherwise during instance creation, the default database name is mall.
  2. Restore your database backup to your Version 8.0 environment by using one of the following methods:
    • DB2Restore your DB2 database
    • OracleSee the database vendor documentation.
      Note: When you restore the Oracle database, the character sets are automatically converted to AL32UTF8.
    Note: When you restore your database, use the same database name for both version 7.0 and version 8.0.