Detection of unsupported features
Last updated
Last updated
While Synapse Analytics supports a broad range of system-level operations, including user management, diagnostics, and configuration through system procedures and catalog views, Microsoft Fabric Warehouse only supports a limited subset of these features. System objects such as sp_addrolemember
, sys.dm_*
views, and T-SQL commands like DBCC
or ALTER DATABASE
are not available in Fabric’s SQL environment.
SQL Tran intelligently detects unsupported features during translation. Instead of attempting to rewrite or remove these constructs, it flags them with diagnostic comments. Important statements are preserved in the translated code, marked clearly for manual review.
This approach ensures that critical administrative or diagnostic logic is not silently lost and highlights areas that require human attention, saving time and reducing the risk of overlooked incompatibilities.
(For more information, see the following emulation reference page: )
Synapse Analytics:
Fabric Warehouse (generated by SQL Tran):
In the example shown, a procedure contains a SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
statement — a feature that is not supported in Fabric.
SQL Tran detects this unsupported construct and preserves the statement in the target SQL while emitting a diagnostic comment to flag the limitation.
This ensures that intentional constructs are not discarded during translation and can be reviewed and adjusted manually where necessary.