Migrating the WebSphere Commerce Developer database using the Migration wizard

The Migration wizard provides a graphical interface to help you perform both the premigration check and the migration on your WebSphere Commerce database. To run database migration, you must open the Migration wizard and follow the steps that are presented.The Migration wizard server runs on the workstation where WebSphere Commerce Developer Version 8.0 is installed. The WebSphere Commerce Migration wizard client, which is the graphical interface you interact with, can be installed on any workstation that supports graphics.

Before you begin

  1. DB2 Run the updatedb2configuration.bat script.
  2. Copy the version 7.0 WCDE_installdir \xml\config\wc-server.xml file to your version 8.0 environment if the file doesn't exist there. If you installed version 7.0 and version 8.0 on the same environment, this step is not required.
    Note: During the migration, you are prompted for the location of this XML file.

Procedure

  1. Start the Migration wizard server.
    1. Open a command prompt.
    2. Go to directory WCDE_installdir /bin.
    3. Enter the following command to start the wizard:
      • wcimServer.bat [-port port_number -loglevel log_level]
      Where:
      port_number
      The number of the endpoint port. If a number is specified, the value must be 1024 - 65535. If a number is not specified, the default number is 10,999.
      log_level
      The level of logging can be set to ERROR, WARNING, NORMAL, DEBUG, or VERBOSE. The default value is VERBOSE.
    4. Wait for the following message to be displayed: 
      Event: WCIM server started with protocol default at port 10,999.
      The message indicates that the server started successfully.
  2. To start the Migration wizard client.
    1. Open a separate command prompt.
    2. Navigate to directory WCDE_installdir /bin.
    3. Depending whether your client workstation is local or remote from the server workstation, complete one of the following tasks:
      • If the Migration wizard client is on the same workstation as the Migration wizard server, run the following command:
        • wcimclient.bat
      • If the Migration wizard client is on a workstation remote from the Migration wizard server, run the following command:
        • wcimclient.bat -hostname hostname [-port port_number -loglevel log_level]
        Where:
        hostname
        The hostname of the workstation where the Migration wizard server is running.
        port_number
        The number of the endpoint port. If a number was specified to start the Migration wizard server, the same port number value must be specified for the client.
        log_level
        The level of logging can be set to ERROR, WARNING, NORMAL, DEBUG, or VERBOSE. The default value is VERBOSE.
  3. The Migration wizard's default user is wcimadmin and the default password is wcimibm. Use these values to sign in.
    Note: The first time you log in, you are to change the password.
  4. Interact with the Migration wizard to perform a database check and database migration.
    Tips:

    • If you are migrating an Apache Derby database, you must pass the full database path for the Database name value when prompted, for example, W:\WCDE_ENT80\db\mall.

    • To access the online help, click Help > Online Help.
    • Refer to the following Migration wizard log file to address any warnings or errors during the database check and migration: WCDE_installdir/logs/WCIM/wcim.server.yyyy.mm.dd_hh.mm.ss.log
    • If you are migrating an Apache Derby database, and either the database check or migration fails, you must terminate the Wizard server batch job and Wizard client batch job before you rerun the check or migrate actions.

What to do next