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