What it does
- Analyzes stored procedures for migration complexity
- Evaluates views and their dependencies
- Assesses translation difficulty for SQL logic in the source dialect
- Generates an assessment dashboard with an executive summary and detailed findings
- Lets you refine and update the assessment through chat
Create an agent
- Go to the Agents tab in the left sidebar.
- Click Create Agent.
- Select Migration Assessment as the agent type.
- Select the source data source, and add a name and description for the agent.
- Select the target database type (for example, Snowflake, BigQuery, Databricks).
- Click Create to save.
Run an agent
- Go to the Agents tab and click the agent you created.
- Click Run to start the assessment. The agent analyzes your source database and produces an assessment dashboard.
- You can create multiple runs and view previous runs at any time.
Assessment dashboard
When the run completes, the agent produces an assessment dashboard you can use to evaluate migration readiness. The dashboard includes:| Section | Description |
|---|---|
| Executive Summary | High-level migration readiness score and key findings |
| Procedure Analysis | Per-procedure complexity assessment and migration notes |
| View Analysis | View dependency mapping and complexity flags |
| Translation Analysis | Assessment of SQL constructs that require translation, with complexity estimates |