SQL Tran Docs
  • Overview
    • About
    • Getting started
    • Object lifecycle
    • Why is there no AI inside?
    • Performance considerations
    • Security considerations
    • Assessment
    • Unlocking projects
    • Interface walk-through
    • Translation scenarios
    • Prerequisites for Azure Marketplace deployment
  • Emulation scenarios
    • Emulation in SQL Tran
    • SQL Server to Fabric Warehouse
      • Data types
      • Case sensitivity
      • Cursors
        • Basic cursor loop
        • Cursor types
        • Fetch direction modes
        • Cursors in control flow
        • Nested cursors
        • Data modification cursors
        • Multiple cursors
        • Subqueries and filtering
      • Named procedure parameters
      • Result set limiting
      • MERGE statements
      • Computed columns
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Sequences
      • Unsupported system features
    • Synapse Analytics to Fabric Warehouse
      • Data types
      • Case sensitivity
      • Named procedure parameters
      • Result set limiting
      • MERGE statements
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Materialized views
      • Create table as select (CTAS)
      • Unsupported system features
    • SQL Server to Synapse Analytics
    • Oracle to PostgreSQL
  • Project wizard
    • Source database
    • Target database
    • Wrapping up
  • Projects
    • Project list
    • Overview
    • Workspace
    • Reports
    • Tests
    • Scratch pad
    • Settings
      • Project name
      • Mapping
      • Database connections
    • Navigation
    • Object complexity
    • Static analysis
    • Translation errors
    • Exporting and importing projects
  • Workspace
    • Object tree
    • Data lineage
    • Code
    • Actions
      • Overriding source
      • Overriding target
      • Ignoring objects
  • Tests
    • Workflow
    • Configure SQL Tran
    • Connecting to databases
      • Fabric Warehouse
      • Synapse Dedicated SQL Pool
      • Azure SQL Database, Azure SQL Managed Instance, Microsoft SQL Server
    • Tables
    • Views
    • Procedures
    • Functions
    • Triggers
    • Performance tests
  • Scripter
    • About
    • Supported databases
    • SQL Server
    • Azure SQL
    • Synapse Dedicated Pool
    • Oracle
    • PostgreSQL
    • MySQL
  • Microsoft training - SQL Tran
    • Introduction
    • Licensing plans
    • Deploying and activating
    • Creating a new project
    • Exploring the "Overview" screen
Powered by GitBook
On this page
  • Access depends on your plan
  • Add/update scripts
  • Action menu
  • Overview pane
  • Object statistics
  • Object life cycle
  • Parsing
  • Analysis
  • Translation
  • Creation
  • Testing
  • Complexity of objects
  • Most complex objects
  • Errors
  • Real-time updates
  1. Microsoft training - SQL Tran

Exploring the "Overview" screen

PreviousCreating a new project

Last updated 4 days ago

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.


Action menu

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.


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 life cycle

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


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

  • Lines of Code (LoC)

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.


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.

"Overview" screen
"Add/update scripts" button
"Actions" menu and download script options
"Overview" pane
Object statistics and lines of code
Object lifecycle progress overview
"Parsing" stage details
"Analysis" stage details
"Translation" stage details
"Creation" stage details
"Testing" stage details
"Complexity of objects" histogram
"Most complex objects" panel
Error log panel