Validation Reports

You can download validation reports in JSON format from the Task Completion screen as highlighted:

Task_completed__1_.png

Follow these steps to get detailed validation reports:

  1. You can get your detailed validation reports by hitting the following API: https://get-validation-reports-142-870-master-proxy.devflows.devfactory.com/
  2. Do a POST request.
  3. With the following Payload: 
    {
      "task_id": <task_id>,
      "source_db_name": <source_db_name>,
      "validation_type": <validation_type>
    }

    Fields

    task_id

    id of the migration task

    source_db_name  (optional) 

    to get report only of a particular db in a task

    validation_type (optional)

    "pre-migration-validation-summary" or "pre-migration-validation-details" or "post-migration-schema-validation" or "post-migration-data-validation"

 

Validation report structures:

  1. Pre-migration validation report

    {
    "summary": [
    {
    "id": 90,
    "task_id": 56,
    "db_name": "northwind",
    "validation_type": "pre-migration-validation-summary",
    "report": []
    }
    ]
    }

  2. Post-migration schema validation report

    Sample secondary schema migration stats JSON report.

  3. Post-migration data validation report 

    Report type: JSON

    {
      "tables_summary": {
          "source": 0,
          "target": 0,
          "common": 0,
          "matched": 0,
          "changed": 0,
          "missing": 0,
          "unexpected": 0
      },
      "tables_diff": {
          "source": [],
          "target": [],
          "common": [],
          "matched": [],
          "changed": [],
          "missing": [],
          "unexpected": []
      },
      "table_row_counts": {
          "source": {
              "<table_name>": 0
          },
          "target": {
              "<table_name>": 0
          },
          "common": [],
          "matched": [],
          "changed": [],
          "missing": [],
          "unexpected": []
      },
      "table_checksums": {
          "source": {
              "<table_name>": 0
          },
          "target": {
              "<table_name>": 0
          },
          "common": [],
          "matched": [],
          "changed": [],
          "missing": [],
          "unexpected": []
      },
      "row_checksums": {}
    }

Attachments

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request