Updated on 2025-10-11 GMT+08:00

Importing Cloud Resource Details

You can import CSV-formatted resource details exported from Alibaba Cloud or Azure directly into MgC. After the import is complete, you can view the resource details on the MgC console. With the imported details, you can get recommendations for suitable Huawei Cloud resources.

Exporting Resource Details with the Alibaba Cloud Console

The supported Alibaba Cloud resources are:

  • Elastic Compute Service (ECS) instances and cloud disks
  • Object Storage Service (OSS) buckets
  • ApsaraDB RDS for MySQL instances
  • ApsaraDB RDS for Redis instances
  1. Sign in to the Alibaba Cloud ECS console.
  2. On the Overview page, choose Export Data > Instances to export a list of all ECS instances.

  3. Choose Export Data > Disks to export a list of all cloud disks.
  4. Open the instance list and the disk list and adjust the resource information if needed. Ensure that the lists contain the necessary information.

    List

    Mandatory Fields

    Instance list

    Instance ID, OS, instance specifications, CPU, and memory

    Disk list

    Instance ID, disk ID, capacity (GiB), and disk attributes

  1. Sign in to the OSS console.
  2. In the navigation pane, choose Buckets.
  3. Click the icon in the upper right corner of the list. The Export Bucket List dialog box is displayed.

  4. Select the information to be exported and click OK.
  1. Sign in to the Alibaba Cloud ApsaraDB RDS for MySQL console.
  2. In the navigation pane on the left, choose Instances. Select a region in the upper part of the page.
  3. Filter all MySQL instances in the Database Engine column and click the icon in the upper right corner of the list.

  4. In the displayed dialog box, select the information to be exported. Click OK. The system exports the instance information to a CSV file and automatically downloads the file.
  5. Modify the exported CSV file so MgC can parse the file content.

    1. Use a file editor to open the CSV file and search for PrivatePort(A network port,) in the table header.
    2. Delete the comma (,) from this field and save the file. The correct format is PrivatePort(A network port).

  1. Sign in to the Alibaba Cloud ApsaraDB for Redis console.
  2. In the navigation pane on the left, choose Instances. Select a region in the upper part of the page.
  3. In the lower left corner of the page, expand and click Select All.

  4. Click the icon in the upper right corner of the list. In the dialog box that is displayed, select the information to be exported.

  5. Click OK. The system exports the instance information to a CSV file and automatically downloads the file.
  6. Modify the exported CSV file so MgC can parse the file content.

    1. Use a file editor to open the CSV file.
    2. Add a comma (,) at the end of the table heading line and save the file.

      The following shows an example table header before modification:

      ID,Name,Quantity

      The following shows the table header after modification:

      ID,Name,Quantity,

Exporting Resource Details with Alibaba Cloud Resource Management

You can export all resource details at once or choose specific types like servers and databases individually.

  1. Sign in to the Alibaba Cloud Resource Management console.
  2. In the navigation pane on the left, choose Resource Center > Advanced Search.
  3. In the search box on the right of the page, enter SQL statements in the Temporary Query 1 box. Alternatively, click the plus sign (+) to open a new tab and write query statements. Use the following SQL statements for query:

    SELECT
      resource_type,
      resource_id,
      resource_name,
      region_id,
      zone_id,
      create_time,
      resource_group_id,
      tags,
      ip_addresses,
      vpc_id,
      v_switch_id,
      properties
    FROM
      resources
    ORDER BY
      region_id,
      resource_type,
      resource_id

  4. Click Run.
  5. Click the Query Result tab to view the query results.
  6. Export the query results to a CSV file and save the file to the local PC. Click the download button on the right and set Format to Close on the Report Settings page.

  1. Sign in to the Alibaba Cloud Resource Management console.
  2. In the navigation pane on the left, choose Resource Center > Advanced Search.
  3. In the search box on the right of the page, enter SQL statements in the Temporary Query 1 box. Alternatively, click the plus sign (+) to open a new tab and write query statements. Use the following SQL statements for query:

    SELECT
      resource_type,
      resource_id,
      resource_name,
      region_id,
      zone_id, 
      create_time, 
      resource_group_id,
      ip_addresses,
      tags,
      vpc_id,
      v_switch_id,
      properties ->> 'InstanceId' as instance_id,
      properties ->> 'CreditSpecification' as credit_specification,
      properties ->> 'OSName' as os_name,
      properties ->> 'HostName' as host_name,
      properties ->> 'Status' as status,
      properties ->> 'Description' as description,
      properties ->> 'InstanceType' as instance_type,
      properties ->> 'InstanceTypeFamily' as instance_type_family,
      properties ->> 'ImageId' as image_id,
      properties ->> 'Cpu' as cpu,
      properties ->> 'Memory' as memory,  
      properties -> 'PublicIpAddress' ->> 'IpAddress' as public_ip_address,
      properties -> 'VpcAttributes' -> 'PrivateIpAddress' ->> 'IpAddress' as private_ip_address,
      properties -> 'EipAddress' ->> 'IpAddress' as eip_address_ip,
      properties -> 'EipAddress' ->> 'Bandwidth' as bandwidth, 
      properties ->> 'ExpiredTime' as expired_time,
      properties -> 'SecurityGroupIds' ->> 'SecurityGroupId' as security_group_id,
      properties ->> 'Size' as disk_size,
      properties ->> 'DeleteWithInstance' as delete_with_instance,
      properties ->> 'DeleteAutoSnapshot' as delete_auto_snapshot,
      properties ->> 'Type' as disk_type,
      properties ->> 'Encrypted' as disk_encrypted,
      properties ->> 'DetachedTime' as disk_detached_time,
      properties ->> 'AutoSnapshotPolicyId' as auto_snapshot_policy_id,
      properties ->> 'IOPS' as iops,
      properties ->> 'IOPSRead' as iops_read,
      properties ->> 'IOPSWrite' as iops_write,
      properties ->> 'PerformanceLevel' as performance_level,
      properties ->> 'SourceSnapshotId' as disk_source_snapshot_id
    FROM
      resources 
    WHERE
      resource_type = 'ACS::ECS::Instance' OR resource_type = 'ACS::ECS::Disk'

  4. Click Run.
  5. Click the Query Result tab to view the query results.
  6. Export the query results to a CSV file and save the file to the local PC. Click the download button on the right and set Format to Close on the Report Settings page.

  1. Sign in to the Alibaba Cloud Resource Management console.
  2. In the navigation pane on the left, choose Resource Center > Advanced Search.
  3. In the search box on the right of the page, enter SQL statements in the Temporary Query 1 box. Alternatively, click the plus sign (+) to open a new tab and write query statements. Use the following SQL statements for query:

    SELECT
      resource_type,
      resource_id,
      resource_name,
      region_id,
      zone_id, 
      create_time, 
      resource_group_id,
      ip_addresses,
      tags,
      vpc_id,
      v_switch_id,
      properties ->> 'InstanceId' as instance_id,
      properties ->> 'DBInstanceDescription' as description,
      properties ->> 'DBInstanceType' as db_instance_type,
      properties ->> 'DBInstanceClass' as db_instance_class,
      properties ->> 'DBInstanceClassType' as db_instance_class_type,
      properties ->> 'Category' as category,
      properties ->> 'DBInstanceCPU' as db_instance_cpu,
      properties ->> 'DBInstanceMemory' as db_instance_memory,
      properties ->> 'MaxIOPS' as max_iops,
      properties ->> 'DBInstanceStorage' as db_instance_storage,
      properties ->> 'Engine' as engine,
      properties ->> 'EngineVersion' as engine_version,
      properties ->> 'InstanceNetworkType' as instance_network_type,
      properties ->> 'PayType' as pay_type,
      properties ->> 'ExpireTime' as expire_time,
      properties ->> 'MaxConnections' as max_connections
    FROM
      resources
    WHERE
      resource_type = 'ACS::RDS::DBInstance'

  4. Click Run.
  5. Click the Query Result tab to view the query results.
  6. Export the query results to a CSV file and save the file to the local PC. Click the download button on the right and set Format to Close on the Report Settings page.

Exporting Resource Details with Azure Resource Graph

You can export all resource details.

  1. Sign in to the Azure portal.
  2. Search for and select Resource Graph using the search box at the top of the page.
  3. In the query window on the page, click New query to create a query. On the new tab page, enter the following query statement:

    resources

  4. Click Run query.
  5. Click the Results tab to view the query results.
  6. Click Download as CSV to export the query results as a CSV to the local PC.

Importing Cloud Resource Details

You can import data exported from Resource Management or cloud services.

  1. Sign in to the MgC console. In the navigation pane, under Project, select your application migration project from the drop-down list.
  2. In the navigation pane, choose Source Resources.
  3. Click the Import tab. Then click the Import card.

    Figure 1 Import

  4. Click the Cloud resources option, select the source cloud platform, choose the resource type to be imported from the Resource Type drop-down list, and upload the corresponding resource list.

    Figure 2 Selecting a resource type

    Only CSV files encoded in UTF-8 format and with English table headers can be imported. The size of a single file cannot exceed 50 MB. For details about how to convert the encoding format of a CSV file to UTF-8, see How Do I Convert the Encoding Format of a CSV File to UTF-8?

    Resource Type

    Procedure

    Remarks

    All

    Click Add under Resource List and upload the exported Alibaba Cloud resource list or Azure resource list.

    • Supported Alibaba Cloud resources include ECS instances and cloud disks, RDS database instances, PolarDB database instances, and lightweight application servers.
    • Supported Azure resources include Virtual Machines, Azure Database for MariaDB, Azure Database for MySQL, Azure Database for PostgreSQL, Azure SQL, Azure SQL Database (based on Microsoft SQL Server), and Azure SQL Managed Instance.

    Servers

    Click Add under Resource List and upload the exported server list.

    This option is only available for Alibaba Cloud.

    Databases

    Click Add under Resource List and upload the exported database resource list.

  5. Click Confirm. The Task Center page is displayed. After the resource list is uploaded, return to the Source Resources page and view the imported resources on the corresponding tab.
  1. Sign in to the MgC console. In the navigation pane, under Project, select your application migration project from the drop-down list.
  2. In the navigation pane, choose Source Resources.
  3. Click the Import tab. Then click the Import card.

    Figure 3 Import

  4. Click the Cloud resources option, select the source cloud platform, choose the resource type to be imported from the Resource Type drop-down list, and upload the corresponding resource list.

    Figure 4 Selecting a resource type

    Only CSV files encoded in UTF-8 format and with English table headers can be imported. The size of a single file cannot exceed 50 MB. For details about how to convert the encoding format of a CSV file to UTF-8, see How Do I Convert the Encoding Format of a CSV File to UTF-8?

    Resource Type

    Procedure

    Remarks

    Servers

    1. Click Add under Resource List and select the exported ECS list.
    2. Click Add under Cloud Disk List and select the exported disk list.

    This option is only available for Alibaba Cloud.

    Redis

    Click Add under Resource List and select the exported Redis instance list.

    Object storage

    Click Add under Resource List and select the exported OSS bucket list.

    Databases

    Click Add under Resource List and select the exported RDS for MySQL instance list.

  5. Click Confirm. The Task Center page is displayed. After the resource list is uploaded, return to the Source Resources page and view the imported resources on the corresponding tab.