Azure SQL Database Mirroring Primary key data type issue

[dawiej]

I am trying to mirror some tables from an Azure SQL database into Fabric.

This is the defintion of the source table:

When setting up the replication in the the 'Choose data' dialog I get the follow error for the specific table although the Id column is an int:

This table can't be mirrored to Fabric because the primary key column uses one of the following data types: computed types, user-defined types, geometry, geography, hierarchy ID, SQL variant, timestamp, datetime2(7), datetimeoffset(7) or time(7).

Please advise

[idrismotiwala]

@dawiej , this is a known limitation where certain datatypes used in a table as primary key cannot be mirrored. Link to public docs https://learn.microsoft.com/en-us/fabric/database/sql/mirroring-limitations#column-level

Also, there is a known issue where one of these data types is a unique key constraint that we plan to roll out the fix in couple of months.

[dawiej_gendac]

Thanks @idrismotiwala for clearing that up. There is a unique constraint on that table that includes a datetimeoffset column.

[dawiej]

@idrismotiwala