Creating a new project
Last updated
Last updated
Now that SQL Tran is deployed and activated, you're ready to begin your first migration — from Azure Synapse Analytics to Microsoft Fabric Warehouse.
Click the New project
button.
In the Select source database
step, click Azure Synapse Analytics
.
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.
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.
In this scenario, the only compatible target for Synapse is Fabric Warehouse. Click the Fabric Warehouse
button to proceed.
Enter a name for the project — for example, Synapse to Fabric Warehouse
.
Click Next
to continue.
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.)