Get a pre-migration analysis report
Get a pre-migration analysis report.
GET /analysis/{projectId}/report
curl \ --request GET 'http://127.0.0.1:8278/api/v1/analysis/{projectId}/report' Response examples (200)
{ "id": "string", "projectId": "string", "generatedAt": "2025-05-04T09:42:00Z", "preflightChecks": [ { "name": "string", "migrationMode": "SNAPSHOT", "passed": true } ], "rules": [ { "id": "string", "dboType": "TABLE", "ruleType": "TASK", "entityName": "string", "detectionText": "string", "difficulty": "HIGH", "mitigationText": "string", "category": "DATA_TYPE", "incompatibleFeatureType": "ORACLE-PACKAGE" } ], "dbMetrics": { "totalDbSize": 42, "readHeavyTables": [ { "database": "string", "schema": "string", "name": "string" } ], "writeHeavyTables": [ { "database": "string", "schema": "string", "name": "string" } ], "allTables": [ { "path": { "database": "string", "schema": "string", "name": "string" }, "dataSize": 42, "rowCount": 42, "readCount": 42, "writeCount": 42, "readWriteClassification": "READ_HEAVY", "columns": { "additionalProperty1": { "type": { "defaultMongoFieldType": "AUTO", "databaseSpecificType": "string", "precision": 42, "scale": 42 }, "ordinalPosition": 42, "primaryKey": { "name": "string" }, "foreignKey": { "name": "string", "schema": "string", "table": "string", "column": "string", "cardinality": "UNKNOWN", "synthetic": true }, "nullable": true, "autoIncremented": true, "generated": true, "hidden": true, "indexed": true, "uniqueIndexed": true }, "additionalProperty2": { "type": { "defaultMongoFieldType": "AUTO", "databaseSpecificType": "string", "precision": 42, "scale": 42 }, "ordinalPosition": 42, "primaryKey": { "name": "string" }, "foreignKey": { "name": "string", "schema": "string", "table": "string", "column": "string", "cardinality": "UNKNOWN", "synthetic": true }, "nullable": true, "autoIncremented": true, "generated": true, "hidden": true, "indexed": true, "uniqueIndexed": true } } } ], "allStoredProcedures": [ { "path": { "database": "string", "schema": "string", "name": "string" }, "definition": "string" } ], "allTriggers": [ { "path": { "database": "string", "schema": "string", "name": "string" }, "definition": "string" } ], "allViews": [ { "path": { "database": "string", "schema": "string", "name": "string" }, "definition": "string" } ] }, "databaseMetadata": { "databaseVersion": "string", "connectionId": "string", "connectionName": "string", "connectionUrl": "string", "databaseType": "string", "connectionType": "DEMO" }, "healthScore": 42.0, "resolvedRules": [ "string" ], "takeaways": [ { "type": "DATA_TYPE", "value": 42.0 } ], "uniqueDboAlerts": { "task": 42, "risk": 42, "notice": 42, "none": 42 }, "detectionCountsByDboType": { "additionalProperty1": { "severityCountsByDetectionCategory": { "*": { "task": 42, "risk": 42, "notice": 42, "none": 42 } } }, "additionalProperty2": { "severityCountsByDetectionCategory": { "*": { "task": 42, "risk": 42, "notice": 42, "none": 42 } } } }, "errors": [ "string" ] } Response examples (404)
{ "jobId": "string", "message": "string", "description": "string", "timestamp": "2025-05-04T09:42:00Z" }