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
  • 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 4 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 server to connect to

  • Authentication – choose the authentication method (e.g., SQL Server Authentication), and if applicable, enter your Username and Password

  • 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.

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