Code translation and emulations

When examining the source and target SQL in the Workspace screen, you’ll notice that SQL Tran applies a comprehensive and intelligent translation process to adapt the SQL code for Microsoft Fabric Warehouse.

This translation is performed automatically during project creation by SQL Tran’s powerful engine, ensuring compatibility with Fabric’s SQL surface and significantly reducing manual intervention.

A key part of this process is emulation. When a feature is available in the source database (e.g., Synapse Analytics), but unsupported in the target database (e.g., Fabric Warehouse), SQL Tran intelligently emulates the missing functionality.

This ensures that the translated code preserves the original behavior while minimizing manual adjustments. SQL Tran’s emulations are highly reliable, consistently applied across all database objects, and designed for large-scale migrations.

SQL Tran’s powerful translation engine in action

In the following pages, we will explore the key emulations SQL Tran performs automatically during the migration process.