MSCM Data Migration

If you are upgrading MSCM and need to test against production data, you may want to have multiple testing passes.  This article will help you to refresh your MSCM database, even if the versions differ.  (The MSCM install procedure updates the database for you when an older version is found).

Uninstall MSCM

  1. Log into the server as Lawson (or as the install user)
  2. Open a command prompt as administrator
  3. Navigate to <installdir>/config
  4. Run the following commands
    1. uninstallmscm
    2. undeploymscm
    3. Verify services as prompted
  5. Verify that the MSCM application has been removed from WebSphere

Restore Database

  • Overwrite the destination database with the desired data set

Re-install MSCM

  1. Log into the server as Lawson (or as the install user)
  2. Open a command prompt as administrator
  3. Navigate to <installdir>/config
  4. Run the following commands
    1. webspheregraft
    2. installschedulertableprefix
    3. installmscm
    4. deploy
    5. Verify services as prompted
  5. Start the mscm application in WebSphere