Forum Discussion
Solved
SQL Server Mirroring - special characters
Copy Job cannot handle special characters (eg. /) in column names - does SQL server Mirroring have the same issue - the documentation states that special characters are managed - list a number - but ...
Hi Magic_Mads,
Microsoft Fabric relies on Delta Lake and Parquet formats under the hood for storage and querying. These technologies, along with Fabric’s mirroring and Lakehouse architecture, impose restrictions on special characters in column names due to file system compatibility and query engine parsing rules.
column names with special characters may cause errors in mirroring, dataflows, and Spark operations. The / character, although sometimes accepted in SQL Server, can break schema inference and querying in Fabric.
Thanks,
Prashanth Are
MS Fabric community support
To clerify - Fabric Mirror from SQL Server on-prem to Fabric Lakehouse