You can download validation reports in JSON format from the Task Completion screen as highlighted:
Follow these steps to get detailed validation reports:
- You can get your detailed validation reports by hitting the following API: https://get-validation-reports-142-870-master-proxy.devflows.devfactory.com/
- Do a POST request.
-
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:
-
Pre-migration validation report
{
"summary": [
{
"id": 90,
"task_id": 56,
"db_name": "northwind",
"validation_type": "pre-migration-validation-summary",
"report": []
}
]
} -
Post-migration schema validation report
Sample secondary schema migration stats JSON report.
-
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": {}
}