---
title: "Get the Database assessment details"
method: GET
path: "/migration_assessment_v2"
tags: ["voyager-info"]
---

# Get the Database assessment details

`GET /migration_assessment_v2`

Get the Database assessment details

## Query parameters

- `uuid` string, uuid, required

## Response `200`

Response for migration assessment page

- object
  - `data` MigrationAssessmentReport — Details of the migration assessment report
    - `operating_system` string
    - `voyager_version` string
    - `target_db_version` string
    - `assessment_status` boolean
    - `summary` AssessmentReportSummary — API for getting migration assessment summary
      - `migration_complexity` string
      - `migration_comlexity_explanation` string
      - `estimated_migration_time` string
      - `summary` string
    - `source_environment` SourceEnvironmentInfo — Assessment source environment (node/VM) details
      - `total_vcpu` string
      - `total_memory` string
      - `total_disk_size` string
      - `no_of_connections` string
    - `source_database` SourceDatabaseInfo — Source Database details
      - `table_size` integer
      - `table_row_count` integer
      - `total_table_size` integer
      - `total_index_size` integer
    - `target_recommendations` TargetClusterRecommendationDetails — Recommendations for the Target YugabyteDB cluster
      - `recommendation_summary` string
      - `target_cluster_recommendation` TargetClusterSpec — schema for target cluster cpu, memory
        - `num_nodes` integer
        - `vcpu_per_node` integer
        - `memory_per_node` integer
        - `connections_per_node` integer
        - `inserts_per_node` integer
      - `target_schema_recommendation` TargetSchemaRecommendations — Target YugabyteDB cluster schema recommendations
        - `no_of_colocated_tables` integer
        - `total_size_colocated_tables` integer
        - `no_of_sharded_tables` integer
        - `total_size_sharded_tables` integer
    - `recommended_refactoring` RefactoringCount[]
      - `sql_object_type` string
      - `manual` integer
      - `automatic` integer
      - `invalid` integer
    - `assessment_issues` AssessmentCategoryInfo[]
      - `category` string
      - `category_description` string
      - `issues` AssessmentIssueInfo[]
        - `type` string
        - `name` string
        - `description` string
        - `count` integer
        - `impact` string
        - `objects` UnsupportedSqlObjectData[]
          - `object_type` string
          - `object_name` string
          - `sql_statement` string
        - `docs_link` string
        - `minimum_versions_fixed_in` string[]
    - `notes` string[]

## Other responses

- `400` — API Error
- `500` — API Error

---

[API](https://skmtc.net/yugabyte/apis/yugabyte-cloud.md) · [All operations](https://skmtc.net/yugabyte/apis/yugabyte-cloud/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/yugabyte/yugabyte-cloud/versions/a851ee3a0a88/schema)