Services
Blog Login
SQL Tran
Overview
Go To App
  • 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
      • Result set limiting
      • Computed columns
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Sequences
      • Table variables
      • Multi-statement table-valued functions
      • Unsupported system features
    • Synapse Analytics to Fabric Warehouse
      • Data types
      • Case sensitivity
      • Named procedure parameters
      • Result set limiting
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Materialized views
      • Create table as select (CTAS)
      • Limitation detection
    • 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
    • Understanding the Target screen
    • Code translation and emulations
    • Using the Reports screen
    • Testing with SQL Tran
      • Connecting to staging databases
      • Actions menu in testing
      • Creating the target staging schema
      • Verifying schema in the staging databases
      • Refreshing project metadata
      • Schema verification after refresh
      • Using the Actions dropdown
      • Fixing translation errors
      • Examining the Tests screen
    • Working with the Scratch pad
  • Microsoft training - Omni Loader

    • Page 1

Overview

Translation scenarios

We support the following translation scenarios. More are coming soon.

Sql Server To Fabric Warehouse Synapse Analytics To Fabric Warehouse Sql Server To Synapse Analytics Oracle To Postgresql
Previous
Interface walk-through
Next
Prerequisites for Azure Marketplace deployment
  • 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
      • Result set limiting
      • Computed columns
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Sequences
      • Table variables
      • Multi-statement table-valued functions
      • Unsupported system features
    • Synapse Analytics to Fabric Warehouse
      • Data types
      • Case sensitivity
      • Named procedure parameters
      • Result set limiting
      • Temporary tables
      • External tables
      • Identity columns
      • Default values
      • Materialized views
      • Create table as select (CTAS)
      • Limitation detection
    • 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
    • Understanding the Target screen
    • Code translation and emulations
    • Using the Reports screen
    • Testing with SQL Tran
      • Connecting to staging databases
      • Actions menu in testing
      • Creating the target staging schema
      • Verifying schema in the staging databases
      • Refreshing project metadata
      • Schema verification after refresh
      • Using the Actions dropdown
      • Fixing translation errors
      • Examining the Tests screen
    • Working with the Scratch pad
  • Microsoft training - Omni Loader

    • Page 1

Spectral Core

We are fully independent and fully distributed team building state of the art database software.

Solutions

  • Full Convert
  • Omni Loader
  • SQL Tran
  • Fabric Migration
  • Safe Boundary

support

  • Customer support

Company

  • About
  • Contact
  • Blog

Legal

  • Privacy
  • Legal & Policies

© 2026 Spectral Core. All rights reserved.