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
  1. Microsoft training - SQL Tran

Working with the Scratch pad

PreviousUsing the Reports screen

Last updated 3 days ago

The Scratch pad in SQL Tran provides a powerful, real-time SQL editing environment designed for experimentation, testing, and rapid iteration. It acts as a sandbox where you can write and evaluate SQL code independently of the source and target database states.

When you enter code in the source editor in the Scratch pad (source pane), SQL Tran immediately translates it into the target SQL dialect (target pane), applying all necessary transformations and emulations to ensure compatibility with the configured target environment (e.g., Microsoft Fabric Warehouse).

This real-time translation enables quick validation of code changes, making it an ideal space for exploring how SQL Tran adapts and emulates different SQL constructs.

Importantly, code created in the Scratch pad:

  • Does not alter the actual source or target databases — it remains entirely isolated.

  • Can reference and interact with existing objects from the source database — just like regular project code would.

  • Is project-specific and persisted, ensuring that each project maintains its own independent Scratch pad that you can return to at any time.

The Scratch pad also benefits from SQL Tran’s advanced integrated development environment (IDE) capabilities. As you type, the built-in static analysis engine validates your code in real time, detecting syntax errors and unresolved references, and providing immediate feedback through underlining and annotations.

This ensures that your code is not only syntactically correct but also semantically aware of database structure.

(Note: The Scratch pad feature is available only in the SQL Tran BYOL (Bring Your Own License) version of SQL Tran.)

Testing table creation code in "Scratch pad"