Migrating data from MSCM v10 to MSCM v11

Perform these steps to migrate the database of inactive or new tenants.

Note: This is only available in the Multi-Tenancy setup.
  1. Select Migration menu.
  2. Select a tenant to migrate on the Tenant drop-down. Only new or inactive tenants are available in the list.
  3. Specify or select the migration parameters:
    S3 Bucket Folder
    The folder where the CSV files are uploaded. For example: /migration/<TENANT_ID>/<DB name>/dbo.
    Note: If the Extract uploaded file option is selected, the S3 Bucket Folder value should be in the format mscm/migration/<TENANT_ID>.
    Version
    The MSCM version of the customer. This is the value from APP_CONFIG table.
    Replication Instance ARN
    The Amazon Resource Name of the DMS replication instance.
    Migration DB Type
    The migration RDS DB type.
    Migration DB Hostname
    The migration RDS hostname.
    Migration DB Port
    The migration RDS port.
    Migration DB Username
    The root user of RDS migration instance.
    Migration DB Password
    The root password of RDS migration instance.
    Tenant DB Server IP
    The IP of the tenant DB.
    LOB Size

    The maximum size of large objects (LOBS) in KB.

    Note:  AWS DMS truncates each LOB so that it's no larger than the maximum LOB size.
    Execute Post Migration Script
    Post migration scripts will be executed when selected.
    Skip Non-Customer Maintained Tables
    The migration will skip tables that are not maintained by customers.
    Note: Select this if migrating a customer from 10.1.8.x and lower.
    Execute DB Repair

    The migration will rerun all MSCM scripts on the tenant DB to insert missing details that are not part of their data

    Note: Enable this if migrating a customer with MPC/RAD only or POU only products.
  4. Click Start to begin the migration process. Monitor the migration process in the Migration Status text area.
  5. Click Delete Resource to delete all the migration resources created for the tenant. This includes DMS endpoints, tasks and replication DB.
  6. Click Clear to delete the values in the Migration Status text area.
  7. Optionally, click Export Migration DMS Logs to download DMS migration logs.
  8. Optionally, click Export Copy Data DMS Logs to download DMS copy data logs.