Exploring the "Overview" screen
Last updated
Last updated
After creating a project, the Overview
screen is the first thing you'll see. This screen acts as an assessment hub, showing a complete snapshot of your database migration progress, statistics, object complexity, and potential issues.
If you're using the SQL Tran Pro
(pay-as-you-go) plan, only the Overview
screen is initially accessible. Other features remain locked until the project is unlocked. With a SQL Tran BYOL
plan, the entire project is fully unlocked from the start.
At the top of the screen is the Add/update scripts
button. This allows you to upload additional scripts after project creation—for example, customer-provided files that need to be translated or incorporated into the project. You can also use it to update existing scripts in the project, replacing or expanding the original input as needed.
Next to the script button is the Action
menu, a dropdown with several options. Most options are disabled until database connections are configured. However, the Download
submenu is available immediately.
Available download options include:
Source script
Source script as ZIP
Commented staging script
Production script
These options allow you to download both the original source scripts and the translated target scripts, in formats suitable for review, archiving, or execution.
Below the top buttons, you'll find the overview pane. This section provides detailed object statistics and lifecycle analysis with visualizations of your project’s state.
Displays counts of Tables
, Views
, Procedures
, and Functions
, along with their respective lines of code (LoC
).
The overview pane also includes a visual breakdown of the migration process across five stages. These stages reflect the complete process by which SQL Tran interprets, transforms, and verifies your source database.
This area is divided into five stages:
Parsing
Analysis
Translation
Creation
Testing
Each stage includes:
Progress bars for each object type
A circular overall progress indicator
Numeric stats (e.g., “79 parsed”, “78 of 79 translated”)
In this stage, SQL Tran analyzes the raw SQL code to build a complete semantic model of your source database.
Performs static analysis to determine data lineage, identify object references, and flag any broken dependencies.
Converts source SQL into the equivalent syntax for the Fabric Warehouse target environment.
Reflects the actual schema creation process in a live staging database in the target environment.
Validates the functional correctness of the translated logic by comparing the behavior between source and target environments:
Table contents
View output
Procedure side effects
Function return values
This histogram grades each object based on a six-point complexity scale:
Very simple
Simple
Medium
Complex
Very complex
Extra complex
In the demo project used here, most objects fall into the simpler categories.
This pane highlights the most complex objects in the database, based on:
Nodes
(parsed syntax tree complexity)
Statements
Lines of Code (LoC
)
Useful for identifying areas that may require additional attention or optimization.
The final pane displays any errors detected during parsing, translation, or testing. This includes SQL syntax issues, unresolved references, or logic mismatches.
The Overview
screen updates dynamically as your project evolves. You can return to it at any time to check progress, review issues, or download updated artifacts. It serves as your central dashboard for tracking the state, progress, and completeness of your migration.