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
andPassword
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) andClient Secret
. The service principal must have appropriate permissions in Synapse.
Database – Specify the name of the database to connect to.
(Note: 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.
Last updated