Migrate > Migrating WebSphere Commerce
Migrate WCS database using the Migration wizard
Overview
Use the information in this section to migrate the WebSphere Commerce v5.6.1 or 6.0 database to the WebSphere Commerce v7.0 level using the Migration wizard.
Pre-requisites...
- WCS v7.0 installed.
- A working WCS v5.6.1 or 6.0 instance.
Database migration flow
Database migration details
The Migration wizard prompts for a database backup and a restore of this backup. If you are migrating the WCS database from one system (source) to another system (target), you should copy the source database backup to the target machine, then restore it to the target database. The restored database backup is what is migrated to keep the current WCS environment functional.
To back up or restore the database:
- DB2 backup overview
DB2 restore overview.Create a database user on the target system that has the same name as the database user on the source system.
- IBM i: Backup and recovery.
- Oracle: See the database vendor manual or information center.
In a test run, the Migration wizard will not allow you to continue until both a database backup and a database restore have been completed. When not performing a test run, the database Migration wizard will not allow you to continue until you have performed a database backup.
The database migration script does not delete any records from the database. In particular, it backs up the original CMDREG, URLREG, and VIEWREG tables by appending "_OLD" to the backup version of the table. For example after the migration table CMDREG_OLD exists.
The database migration script...
- Backups the original table CMDREG as CMDREG_OLD.
- Loads the new bootstrap data needed in the new release on top of table CMDREG
- Backups the table to CMDREG_NEW.
- Restores most settings from the original CMDREG_OLD to the table CMDREG.
A few settings are not restored because these settings might be changed in the new version. If you find that some of the settings are not restored and have them restored, copy the previous setting from the CMDREG_OLD table.
The migration script migrates the URLREG and VIEWREG tables in a similar manner.
Stage database migration
You cannot migrate the staging database.
See also
Related tasks