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
    • Inside the Workspace screen
    • Code translation and emulations
      • Data type emulation
      • Case sensitivity emulation
      • Named parameters emulation
      • Result set limiting emulation
      • Merge statements emulation
      • Identity column emulation
      • Default values emulation
      • Detection of unsupported features
    • Understanding the Target screen
    • Using the Reports screen
    • Working with the Scratch pad
Powered by GitBook
On this page
  • Who we are
  • Product overview
  • Supported migration scenarios
  1. Microsoft training - SQL Tran

Introduction

PreviousMySQLNextLicensing plans

Last updated 2 days ago

Welcome to this training guide on SQL Tran, developed by Spectral Core.

This guide walks you through the complete migration process from Synapse Dedicated SQL Pool to Microsoft Fabric Warehouse, covering every step from deployment to post-migration testing.

Whether you are a hands-on database engineer or an architect overseeing a cloud migration initiative, this document will help you understand and operate SQL Tran effectively.

If you prefer a visual format, a training video is also available. This guide covers the same goals as the video, helping you understand and use SQL Tran effectively, but in a written step-by-step format you can refer to at your own pace.


Who we are

Spectral Core is a trusted software company with over 20 years of expertise in database migration solutions. We offer two complementary tools:

  • Omni Loader – for high-speed, scalable data migration

  • SQL Tran – for SQL code translation, schema generation, and testing

These tools are designed to work independently or together, depending on the scope of your migration project.


Product overview

Omni Loader: enterprise-grade data migration

Omni Loader is distributed as a standalone binary application available for both Windows and Linux. It is capable of migrating hundreds of terabytes of data efficiently—even from a single machine.

  • Security-first design: Omni Loader runs entirely in your infrastructure.

  • Simple setup: No installation required—just unpack and run.

  • Performance at scale: Optimized for parallel processing and minimal resource consumption.

Data flows directly from the source database into Omni Loader and then into Microsoft Fabric Warehouse, ensuring minimal latency and complete data control.

SQL Tran: code translation with zero compromise

SQL Tran is deployed via the Azure Marketplace and runs entirely within your Azure tenant. Spectral Core has no access to your environment, data, or metadata. This architecture provides complete isolation and enterprise-grade security:

  • No data or metadata access

  • No co-administrator privileges

  • No external communication with Spectral Core

SQL Tran requires only a SQL script as input to perform its translation tasks. For users who grant database access, it unlocks more advanced features, including:

  • Target schema creation directly from the application

  • Automated test generation for procedures, views, and functions

  • Table data comparison between source and target environments


Supported migration scenarios

SQL Tran currently supports the following end-to-end migration paths:

  • Synapse Analytics → Fabric Warehouse

  • Azure SQL → Fabric Warehouse

  • SQL Server → Fabric Warehouse

  • Oracle → PostgreSQL (available in private preview)

Additional support is coming soon for the following scenarios:

  • Oracle → Fabric Warehouse

  • Oracle → Snowflake

Each scenario is supported by purpose-built translation and emulation logic that adapts your existing codebase to the architecture and syntax of your chosen target platform.

Step-by-step migration of Synapse to Fabric Warehouse