Migrating your LikeMinds Oracle database
(AIX)(Solaris)(Windows) If you are using Oracle, 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.
- Back up your current LikeMinds database. Refer to the Oracle product documentation for backup instructions.
- Create a new Oracle user for LikeMinds. Refer to the Oracle product documentation to see how to create a new Oracle user.
Note: If the script applies to an existing database, there is no need to create a new Oracle user.
- From a command line window, scroll to the following directory:
- Connect to the database using SQLPlus:
sqlplus user_id/user_password@LikMinds_database_name
- Clean up all user and item data that is not used by the WebSphere Commerce integration by running the lm_dataClean.sql script:
start lm_dataClean.sql
- Migrate the database schema by running the lm_migration.sql script:
start lm_migration.sql
- Switch to the following directory:
Populate the database with the LikeMinds configuration data by running the lm_Props.sql script:
start lm_Props.sql
- Switch back to the following directory:
- (Linux)WC60_installdir/likeminds/migration/oracle
- (Windows)WC60_installdir\likeminds\migration\oracle
Rebuild the LikeMinds database mentor table by running the lm_rebuild_mentor.sql script:
start lm_rebuild_mentor.sql
- Exit the database connection as follows:
quit
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.