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.
Procedure
-
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:
- WC70_installdir/likeminds/migration/oracle
- WC70_installdir\likeminds\migration\oracle
-
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:
-
Migrate the database schema by running the lm_migration.sql
script:
-
Switch to the following directory:
- WC70_installdir/likeminds/config
- WC70_installdir\likeminds\config
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:
- WC70_installdir/likeminds/migration/oracle
- WC70_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: