Migrating HCL Commerce Version 9.1 databases
Migrate HCL Commerce v9.1.x.0 databases (Db2 or Oracle) to
HCL Commerce+ Transaction Server using the
wcim_ant utility. It includes
guidance for Development, Staging, and Production database environments.
Pre-requisite
Before you migrate to HCL Commerce+ Transaction Server from HCL Commerce Version 9.1, review this information to help plan and execute your migration.
- Best practices for Database migration
-
- Backup everything first
- Always complete the backup of the source database before starting migration. Retain backups until post-migration verification is complete.
- Use a Non-Production Environment First
- To uncover potential issues early, perform trial migrations in a development or staging environment.
- Monitor Logs Closely
- Use
-logLevel Verbosefor allwcim_antexecutions. Review the logs immediately after each migration step for errors or warnings. - Set Maintenance Windows
- Schedule the migration during a designated maintenance window to avoid disruption to business operations.
- Post-Migration Validation
- To confirm application stability, test core functionalities like storefront access, catalog browsing, order placement, and admin tools.
- Update SITE Table Correctly
- Ensure the SITE table version is correctly updated and audited as part of the migration checklist.
- High-Level Migration Steps
-
- Back up the 9.1.x.0 database and restore it to the HCL Commerce+ Transaction Server database environment.
- Run pre-migration checks using the wcim_ant tool.
- Perform the database migration using wcim_ant.
- Update the SITE table version.
- Run the updatedb utility from the HCL Commerce+ Transaction Server environment.