Schema Mismatch on Mirror database from SQL Server

[TWorku]

Hi everyone,

I’m having trouble with a mirrored database from SQL Server 2017. The initial synchronization works fine, but when the source data updates, I get a schema mismatch error.

After checking the schema, I found that a column defined as NOT NULL in the source table appears as Is_Nullable = Yes in Fabric. I don’t want to modify the source table schema. I’ve already tried restarting replication and CDC, but the issue persists. The error is as follows.

ErrorCode: SchemaMergeFailure, Message: Failed to write table 'dbo\xxxxxxx' due to schema mismatch. Schema merge failure due to potential invalid input. Cause: Type mismatch for column 'Date'. Incoming type: 'date' (Nullable: True), existing type: 'date' (Nullable: False). 

Has anyone else experienced this or found a workaround?

Thanks in advance for your help!

[lbendlin]

The "not null" is not your issue.  Your issue is that Fabric doesn't support auto increment primary keys.