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. Start a new project
  • 2. Choose the source database
  • 3. Connect to the source
  • 4. Fetch metadata
  • 5. Select the target database
  • 6. Name your project
  • 7. Translation and project creation
  1. Microsoft training - SQL Tran

Creating a new project

PreviousDeploying and activatingNextExploring the Overview screen

Last updated 7 days ago

Now that SQL Tran is deployed and activated, you're ready to begin your first migration — from Azure Synapse Analytics to Microsoft Fabric Warehouse.


1. Start a new project

Click the New project button.


2. Choose the source database

In the Select source database step, click Azure Synapse Analytics.


3. Connect to the source

Choose Source connection to connect directly to your Synapse instance. You could also use Source script to upload a SQL file, but for this example, we'll use a live connection.

Fill in the connection information:

  • Server – enter the name of the Synapse server to connect to

  • Authentication – choose one of the supported authentication methods:

    • Microsoft Entra Managed Identity – Uses an automatically managed Azure AD identity (system-assigned or user-assigned) and requires no credentials to be entered. Ensure that the managed identity has the necessary permissions in Synapse.

    • Microsoft Entra Service Principal – Authenticates using an Azure AD application (service principal). Users must provide the Client ID (Application ID) and Client Secret. The service principal must have appropriate permissions in Synapse.

    • SQL Server Authentication – Uses a traditional Username and Password for authentication. Users must enter credentials for a SQL login created in the Synapse master database. This method is generally considered less secure compared to the Azure AD options.

  • Database – specify the name of the database to connect to

You can save the connection to Favorites for reuse later.

Click Test connection to verify the connection. A success message should confirm the connection is valid.


4. Fetch metadata

Click Next to start the metadata fetch process. SQL Tran will extract schema information from your source database.

This step completes in seconds, even for large databases, and automatically leads to the next step where you select the target database.


5. Select the target database

In this scenario, the only compatible target for Synapse is Fabric Warehouse. Click the Fabric Warehouse button to proceed.


6. Name your project

Enter a name for the project — for example, Synapse to Fabric Warehouse.

Click Next to continue.


7. Translation and project creation

SQL Tran now performs several operations on the source database, such as parsing, static code analysis, and SQL translation. Within a few seconds, your migration project will be fully created and translated.

You’ll now be able to explore and analyze the translated code within the SQL Tran interface.

(Note: For detailed instructions on configuring the required permissions for a service principal, refer to the page.)

Fabric Warehouse
Starting a new project
Selecting the source database
Connecting to Azure Synapse
Fetching metadata from Synapse
Selecting the target database
Naming the project
Project created and translated