Creating a new project

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:

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

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

• Database – Specify the name of the database to connect to.

(For detailed instructions on configuring the required permissions for a service principal, refer to the Fabric Warehouse page. You can refer to the Omni Loader documentation for additional information on configuring connections to Synapse Dedicated Pool and Fabric Warehouse.)

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.