CLM 1.0 to ALM 2.0 - ALE Learnset Manager - 23.1 - 23.1 - Brainware - external

This section provides high level information on how to upgrade from Columbus Learnset Manager to the latest version of ALE Learnset Manager.

1. Ensure that all the existing Columbus servers are stopped. There can be multiple servers located on different machines.
2. Navigate to the install location of CLM on the server. Example: …\ALM\WEB-INF\conf. Open alm-config-db.xml and make a note of the username. This will be required during the installation of ALM 2.0.
3. Add type (INT) column to CPTMS_ACCOUNT for SQL environment by running the following query:

   ALTER TABLE [dbo].[CPTMS_ACCOUNT]
           ADD [type] int NULL 
           CONSTRAINT D_CPTMS_ACCOUNT_type 
           DEFAULT (0);

4. Change the column width by running the following query:

   ALTER TABLE [dbo].[LEARNSET_PROJECT] MODIFY name VARCHAR (256);
   ALTER TABLE [dbo].[LEARNSET_FIELDDECL] MODIFY name VARCHAR (256);
   ALTER TABLE [dbo].[LEARNSET_DOCCLASS] MODIFY name VARCHAR (256);
   ALTER TABLE [dbo].[LEARNSET_DOCCLASS_FIELDDECL] MODIFY name VARCHAR (256);
   ALTER TABLE [dbo].[LEARNSET_DOC] MODIFY filename VARCHAR (256);

5. Uninstall Columbus Learnset Manager by deleting the folder C:\ColumbusWS and C:\Program Files\Apache Software Foundation\Tomcat <installed version>\webapps\columbus.
   Note: Do not delete the database.
6. Install ALE Learnset Manager on the same machine using the same database user credential that was used with the original Columbus Learnset Manager installation.
7. Start the servers.
8. Log on to ALE Learnset Manager and verify if the projects created with the original Columbus Learnset Manager are available.
9. Open each class within a project and save the fields.
10. Re-learn the project.
11. Repeat step 8 through step 10 for each existing project.