Guidelines to copy data from old taxonomy tables to new taxonomy tablesThe purpose of this article is to provide guidance and necessary scripts to copy data from the old taxonomy tables to the new taxonomy tables. This article is helpful for the RCM customers upgrading from the version 11.0.3 or 12.0.2 to 13.0.1. This script is also needed for the customers upgrading to Rome or later versions from earlier versions. As part of RCM version 13.0.1, the taxonomy functionality has been upgraded. As part of this version, the taxonomy related tables are moved from the Regulatory change management application to a new Taxonomy management application. Therefore, data present in the old taxonomy tables should be moved to the new tables.The attached script migrates the data to the new tables. Download the attached file and execute it as a fix script. The attached fix script is used to perform the below tasks. 1) Copy the internal taxonomy from the following tables to the sn_grc_taxonomy_internal_taxonomy table with the appropriate taxonomy class names. sn_grc_reg_change_regulatory_bodysn_grc_reg_change_content_typesn_grc_reg_change_jurisdictionsn_grc_reg_change_themesn_grc_reg_change_sector 2) Copy the taxonomy configuration data from the table sn_grc_reg_change_provider_taxonomy_config to the sn_grc_taxonomy_provider_taxonomy_config table. 3) Copy the external taxonomy data from the below tables to the sn_grc_taxonomy_external_taxonomy table. sn_grc_reg_change_external_regulatory_bodysn_grc_reg_change_external_content_typesn_grc_reg_change_external_jurisdictionsn_grc_reg_change_external_themesn_grc_reg_change_external_sector 4) Update the Regulatory alert table with the new provider and also create taxonomy mappings for the regulatory alert based on the above data NOTE: If any custom taxonomy were created then you can enhance the attached script to complete the migration for the custom taxonomy.