Risk Analysis

Risk Analysis

Every migration includes automated risk scoring for type overflow, missing indexes, broken relations, and dialect incompatibilities.

Request an Assessment
Expert-led delivery·Self-service available
40+
Automated Checks
100%
Coverage per Column
Real-time
Analysis Speed
Included
In Every Migration

Comprehensive risk detection

Every migration runs through 40+ automated checks. High-severity issues block export until resolved.

Type Overflow

High

Source column exceeds target type capacity. Common: VARCHAR2(4000) → VARCHAR(255), NUMBER(38) → Integer.

Oracle: NM_DESC VARCHAR2(4000) → PostgreSQL: description TEXT (not VARCHAR)

Precision Loss

High

Numeric precision/scale not preserved. Oracle NUMBER(10,2) mapped to Integer loses decimals.

Oracle: PRICE NUMBER(10,2) → Prisma: price Decimal @db.Decimal(10,2)

Missing Indexes

Medium

Foreign key columns without indexes cause join performance issues. Agent flags unindexed FK columns.

Table: orders (user_id FK) → Missing: CREATE INDEX idx_orders_user_id ON orders(user_id)

Broken Relations

Medium

Referenced table not in migration scope. Orphaned FKs that would fail in target database.

FK: orders.user_id → users.id → users table not in DDL submission

Dialect Incompatibility

Medium

Features not supported in target dialect. Oracle SEQUENCE, SQL Server IDENTITY, MySQL AUTO_INCREMENT differences.

Oracle: CREATE SEQUENCE seq_user → Prisma: @default(autoincrement())

Default Value Mismatch

Low

SYSDATE, GETDATE(), CURRENT_TIMESTAMP handled differently. Agent normalizes to target dialect.

Oracle: DEFAULT SYSDATE → PostgreSQL: DEFAULT now()

Risk Score in your workflow

1

Analyze

Submit DDL → Agent runs 40+ checks instantly. Risk Score calculated per column.

2

Review

High-severity issues highlighted in diff editor. Click to see exact line and suggested fix.

3

Resolve

Accept Agent suggestion, override manually, or mark as accepted risk. All decisions logged.

4

Export

Only export when Risk Score passes your threshold. Audit trail includes all risk decisions.

Migrate with confidence

Every migration includes full risk analysis. No surprises in production.

Request an Assessment