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.
"Overview" screen
Access depends on your plan
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.
Add/update scripts
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.
"Add/update scripts" button
Actions menu
Next to the script button is the Actions 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.
"Actions" menu and download script options
Overview pane
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.
"Overview" pane
Object statistics
Displays counts of Tables, Views, Procedures, and Functions, along with their respective lines of code (LoC).
Object statistics and lines of code
Object lifecycle
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”)
Object lifecycle progress overview
The subsequent sections delve deeper into every stage of the lifecycle.
Parsing
In this stage, SQL Tran analyzes the raw SQL code to build a complete semantic model of your source database.
"Parsing" stage details
Analysis
Performs static analysis to determine data lineage, identify object references, and flag any broken dependencies.
"Analysis" stage details
Translation
Converts source SQL into the equivalent syntax for the Fabric Warehouse target environment.
"Translation" stage details
Creation
Reflects the actual schema creation process in a live staging database in the target environment.
"Creation" stage details
Testing
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
"Testing" stage details
Complexity of objects
This histogram grades each object based on a six-point complexity scale:
Very simple
Simple
Medium
Complex
Very complex
Extra complex
"Complexity of objects" histogram
In the demo project used here, most objects fall into the simpler categories.
Most complex objects
This pane highlights the most complex objects in the database, based on:
Nodes (parsed syntax tree complexity)
Statements
LoC (Lines of Code)
Useful for identifying areas that may require additional attention or optimization.
"Most complex objects" panel
Errors
The final pane displays any errors detected during parsing, translation, or testing. This includes SQL syntax issues, unresolved references, or logic mismatches. The pane is shown only when errors are present and is hidden if no issues are detected.
Error log panel
Real-time updates
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.
