CPM to CM relational database migration
The migration of CPM data to the new CM schema is executed on database level via prepared SQL script.
Prerequisites
Before the actual data migration can start, the following tables need to be cloned manually from the source database (CPM) to the target database (CM):
-
MSM04_VIEW
-
MSM05_AXIS
-
MSM06_AXIS_HAS_DEVICE_PROP
-
MSM11_VIEW_AGGREGATION
-
DAIS01_ESD_ANALYSIS
-
DAIS02_ESD_ANALYSIS_SEQUENCE
Performing the data migration
-
Connect to the CM database
-
Open the relevant migration script according to database vendor located in shared folder:
\\rb-repobci.de.bosch.com\InternalShare\IAS\IAS2023.02\MigrationCPMToCM\CM -
Copy & execute the script ("cpm-to-cm-migration.sql") against the database
-
Migrated data will be committed only when the script executed successfully. In case of any failure, no data will be migrated. Please reach out to the 3rd level support (Dev team) in this case.
Post migration
Important: When the migration has completed successfully, please do NOT delete the cloned tables!
They should be kept to preserve the old CPM configuration as a backup for any future reference.
To check whether all CM data is migrated, no data should be returned when you execute the script "migration-delta-report.sql" according to located in shared folder:
\\rb-repobci.de.bosch.com\InternalShare\IAS\IAS2023.02\MigrationCPMToCM\CM