Migrate the MSSQL database for the Command Prediction Service microservice

When you upgrade from Teamcenter 13.x / 14.x to Teamcenter 2606, you must run scripts to migrate the existing data, so that the Teamcenter Assistant can store the history of clicks performed by users and predict the next command successfully. Note These migration scripts migrate the command data for Teamcenter Assistant. The scripts do not migrate the actual commands. Prerequisites You must migrate the commands and then run the migration scripts. Changes required for custom commands in updated UI should be completed Create the following lists of custom group commands that you want to migrate: A list of custom group commands that will be visible when you click … or More in the work area toolbar or primary toolbar. A list of custom group commands that will be visible directly on the work area toolbar or primary toolbar. Procedure Copy the template scripts from \tc\microservices\commandprediction_service.zip\tc\db_scripts\tc2312_migration\mssql. To migrate the data generated for commands that are included with the default Teamcenter installation, run the assistant_tc2312_migration_script_mssql.sql script using one of the following methods: To run the script on the command line, use the following command: Copy sqlcmd -S database –U user -P password -i assistant_tc2312_migration_script_mssql.sql OR To run the script using the SQL Server Management Studio, open the assistant_tc2312_migration_script_mssql.sql file in Microsoft SQL Server Management Studio, and in the SQL Editor toolbar, click Query → Execute. To migrate the data generated for custom group commands created by the user that were originally present on the primary toolbar on the right, do the following: Modify the tokens in the assistant_tc2312_custom_migration_script_oracle.sql as follows: Token Example value Description @@LIST_OF_ANCHORS_FOR_WORKAREA_TOOLBAR_MORE@@ ‘Group1’,’Group2’,‘Group3’ List of custom command groups that will be migrated to the More group in work area toolbar. @@LIST_OF_ANCHORS_FOR_WORKAREA_TOOLBAR_MORE@@ ‘Group1’,’Group2’,‘Group3’ List of custom command groups that will be migrated to a group in work area toolbar. Note You do not need to run this script for custom commands, this script is needed only for the custom group commands. Save the modifications and run the script using one of the following methods: To run the script on the command line, use the following command: Copy sqlcmd -S database –U user -P password -i assistant_tc2312_custom_migration_script_mssql.sql OR To run the script using the SQL Server Management Studio, open the assistant_tc2312_custom_migration_script_mssql.sql file in Microsoft SQL Server Management Studio, and in the SQL Editor toolbar, click Query → Execute.