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
  • Object context menu
  • Override source
  • Override target
  • Revert to original
  • Object group context menu
  • Apply {group type} changes to the target database
  • Recreate all {group type} in the target database
  • Drop all target database {group type}
  • Errors tab
  1. Workspace

Object tree

PreviousExporting and importing projectsNextData lineage

Last updated 5 months ago

Objects are grouped by type. Each object has an icon representing its type, but also a stage icon where each stage is a color-coded circle.

First circle is red if we can't parse your code. It's orange if we can parse it but there are broken references.

Second circle will be red if we can't transpile your code and green if we can.

Third circle represents the creation status in the target database. For that to be enabled, you will need to set up connection info in the project settings. If the object was not created yet, the circle will be small, gray, and hollow. If there was an error creating it, it will be red. If it was created successfully, it will be green.

All three dots being green mean you have passed all stages - the object is created in the target and can be used.

If you use tests in your project, you will see four dots instead of three, the fourth one signifying the tests for the specific object.

Object context menu

Override source

When you want to remove non-important code in the source script or make some changes while still letting SQL Tran translate your code in real-time, this is the way to achieve that.

Override target

When you want to start customizing the translated code while starting from the one SQL Tran generates, choose Override target.

Revert to original

This option removes any customizations your may have used in the source or target script and reverts both to their original values.

Object group context menu

When you click the object group, you can have a set of actions applied to the objects of that group.

Apply {group type} changes to the target database

Create group objects in the target database. Applies to only objects with target script change since originally created (or not created at all).

Recreate all {group type} in the target database

Create all group objects in the target staging database even if unchanged.

Drop all target database {group type}

Drop all group objects in the target stagingn database.

Errors tab

If there are errors detected in the project, click the Errors tab to display all errors grouped by type. The navigation is the same as when using the standard object tree.

Right-clicking the object in the tree shows the context menu.