Forum Discussion

TWorku's avatar
TWorku
Frequent Visitor
10 months ago
Solved

Schema Mismatch on Mirror database from SQL Server

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 c...
data engineering
  • TWorku's avatar
    TWorku
    10 months ago

    The Alter command cannot be used on a mirrored database due to its read-only state.

    Thank you to lbendlin  and v-venuppu  for trying to help. The issue has been resolved by:

    1. Disabling and re-enabling CDC on the source database.

    2. Re-enabling CDC on all tables one by one.

    3. Creating a new connection with the latest gateway.

    4. Establishing a new database mirror.

    The solution has been stable and monitored successfully for the last four days

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
10 months ago

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