Diese Seite ist nur auf Englisch verfügbar.

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

Edit this pageDiese Seite bearbeiten

Feedback on this pageFeedback zu dieser Seite