VARCHAR(8000)

[AugustoChaves]

When mirroring from Azure SQL to Fabric all Varchar columns are created on the mirrored database as VARCHAR(8000) instead of preserving their original sizes. Is this by design?

[lbendlin]

It's a current documented limitation. The hope is that this will be lifted.

[AugustoChaves]

I do see documentation of the limit of size for VARCHAR fields being 8000 and VARCHAR(MAX) is in public preview for warehouses but I can't find documentation that states that ALL FIELDS will be converted to VARCHAR(8000) during mirroring. Can you please point me to that doc?

[lbendlin · Accepted solution]

Using VARCHAR() in Microsoft Fabric Lakehouses and SQL Endpoints – Gerhard Brueckl on BI & Data