Forum Discussion

Magic_Mads's avatar
Magic_Mads
Frequent Visitor
1 year ago
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 ...
data engineering
  • v-prasare's avatar
    v-prasare
    1 year ago

    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

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
1 year ago

Hi Magic_Mads 

 

Just curious to ask, Why you have to create mirroring of SQL Server table. Everything is in Microsoft Fabric. Fabric SQL / Fabric Data Warehouse / Semantic Model using Unified Approach.

 

Again SQL Server Mirroring or Azure SQL Mirroring???

  • Magic_Mads's avatar
    Magic_Mads
    Frequent Visitor
    1 year ago

    Hi - I am going to do mirroring from a SQL Server 2019-database hosted on prem - all I need to know is if a / in a column name is handled or nor - if not - morroring is out of the question