SQL Server to Fabric Warehouse

Migration from SQL Server to Fabric Warehouse comes with certain challenges but SQL Tran goes a long way in making it easy and straightforward. As SQL Server is a single-machine database and Fabric Warehouse is a distributed one, there is inevitable a functionality gap coming from the architectural differences.

Fabric Warehouse uses an open Parquet storage for easy portability so certain data types are not behaving exactly the same.

While the whole list of emulations we do is available on a dedicated page, suffice to say that even the name casing rules are not the same, or that there is no NVARCHAR in Fabric Warehouse. SQL Tran even provides extensive rewrites for identity columns and temporary tables usage, where Fabric has yet to release support but what one can expect to find in every single database to be migrated.