topic Re: Azure SQL Database Mirroring Primary key data type issue in SQL database

Azure SQL Database Mirroring Primary key data type issue

dawiej — Tue, 11 Mar 2025 06:48:59 GMT

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

Re: Azure SQL Database Mirroring Primary key data type issue

dawiej — Tue, 11 Mar 2025 06:53:01 GMT

idrismotiwala

Re: Azure SQL Database Mirroring Primary key data type issue

idrismotiwala — Tue, 11 Mar 2025 15:08:43 GMT

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.

Re: Azure SQL Database Mirroring Primary key data type issue

dawiej_gendac — Wed, 12 Mar 2025 07:27:48 GMT

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