Completing the live database migration

After you successfully migrate your live database to version 8.0, there are final database tasks to complete before you can switch your traffic over to the version 8.0 environment.

Procedure

  1. Update your SRCHCONF to contain the new version 8.0 preprocess directory.
    1. Connect to your database.
    2. Run the following SQL command:
      update SRCHCONF set CONFIG = replace(CONFIG, 'old_PreProcessdir', 'new_PreProcessdir');
      Where:
      old_PreProcessdir
      The preprocess directory of the version 7.0 search server.
      new_PreProcessdir
      The preprocess directory of the version 8.0 search server.
  2. Update your SRCHCONFEXT tables to contain the new search web server host name: by running the following command:
    update SRCHCONFEXT set CONFIG = replace(CONFIG, 'old_hostname', 'new_hostname');
    Where:
    old_hostname
    The fully qualified host name of the version 7.0 search web server.
    new_hostname
    The fully qualified host name of the version 8.0 search web server.
  3. If you used catalog filters and pricing rules in version 7.0 and plan on using those functions in version 8.0, you need to enable them manually.
    1. Set the VALUE for the wc.search.entitlement property to 1 by using the following SQL command:
      UPDATE STORECONF SET VALUE='1' WHERE STOREENT_ID=STOREENT_ID AND NAME='wc.search.entitlement';
      Where:
      STOREENT_ID
      The STOREENT_ID for your store.
    2. Repeat for all applicable STOREENT_ID entries.
  4. If you customized any searchable attributes in version 7.0 and plan to use them in version 8.0, you must update KEYS table for the SRCHATTR table by running the following SQL command:
    update keys set counter = case when (select max(srchattr_id) from srchattr) > 
    counter then (select max(srchattr_id) from srchattr) else counter end where tablename = 'srchattr'
  5. Restart the WebSphere Commerce Version 8.0 server.
  6. Update your database to the latest Mod Pack and Fix Pack level by running the updatedb utility.

What to do next

You can now switch traffic from your version 7.0 environment to your version 8.0 environment.