Exploring the Overview screen

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.

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.

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.

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.

Object statistics

Displays counts of Tables, Views, Procedures, and Functions, along with their respective lines of code (LoC).

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”)

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.

Analysis

Performs static analysis to determine data lineage, identify object references, and flag any broken dependencies.

Translation

Converts source SQL into the equivalent syntax for the Fabric Warehouse target environment.

Creation

Reflects the actual schema creation process in a live staging database in the target environment.

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

Complexity of objects

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.

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.

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.

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.