Migrating your LikeMinds DB2 database
If you are using DB2, migrate your database using the following scripts. Run these scripts in order and check their output to make sure no problems have occurred before you proceed to run the next script.
Warning: This procedure is not required when migrating LikeMinds from WebSphere Commerce 5.6.1 to WebSphere Commerce 6.0 and will corrupt your data.
- Back up your current LikeMinds database. Refer to the DB2 product documentation for backup instructions.
- From a command line window, scroll to the following directory:
- Connect to the database using the following SQL statement:
db2 connect to LikeMinds_database_name user user_id using user_password- Clean up all user and item data that is not used by the WebSphere Commerce integration by running the lm_dataClean.sql script:
db2 -tvf lm_dataClean.sql- Migrate the database schema by running the lm_migration.sql script:
db2 -tvf lm_migration.sql- Switch to the following directory:
- Switch back to the following directory:
- Exit the database connection by running:
db2 TERMINATE
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.