Completing the development database migration
After you successfully migrate your development database, additional tasks are required to complete the database migration.
Before you begin
Procedure
-
Update your SRCHCONF to contain the new search preprocess directory by running the following
command:
Where:update SRCHCONF set CONFIG = replace(CONFIG, 'old_PreProcessdir', 'new_PreProcessdir');
- old_PreProcessdir
- The preprocess directory of the version 7.0 search server.
- new_PreProcessdir
- The preprocess directory of the version 8.0 search server.
-
Run the DB2 reorg command.
-
If you are migrating from WebSphere Commerce Version 7 Feature Pack 1, Feature Pack 2, Feature
Pack 3, Feature Pack 4, Feature Pack 5, or Feature Pack 6, and you have configured workspaces and
have already run the update workspaces schema script after migrating, run the following SQL
statement in each workspace write schema:
- Cloudscape:
ALTER TABLE PAGELAYOUT ALTER COLUMN PAGELAYOUTTYPE_ID NULL;
- DB2:
ALTER TABLE PAGELAYOUT ALTER COLUMN PAGELAYOUTTYPE_ID DROP NOT NULL; CALL SYSPROC.ADMIN_CMD ('REORG TABLE PAGELAYOUT');
- Oracle:
ALTER TABLE PAGELAYOUT MODIFY PAGELAYOUTTYPE_ID NULL;
- Cloudscape:
What to do next
- Run the updatedb command to apply the latest Fix Pack to your migrated database. For more information about updating the database, see updatedb utility.
- Migrate your custom assets.