Forum Discussion
If Fabric Mirroring lost Constraints
Hello
Recently I am exploring Fabric Mirroring, which is really fast and continueslly for data integration.
While I am wondering if Mirror bring the constraints from source database tables, as we need the primary key to do merge operation in Spark for next (aggregation) steps.
Mirror will repliate the source database tables into Warehouse in Microsoft OneLake. But seems like it will only copy the table schema and the data, not constraints.
I have a simple test:
- I have Azure SQL database table 'Customer' which has Primary key.
- After Mirroring, cannot see any constraints of the replicated table. Table dbo_customer is the one right after the Mirroring, without any transformation/operation.
Just wanted to double confirm that, if Mirroring lost all the constraints of the source tables?
Can anyone help to have a check. Thanks a lot.
Hi Anonymous
Thanks for using Fabric Community.
Mirroring replicates the 'data'. Constraints and security constructs on the tables are not moved. So just to confirm, the constraints are NOT lost, they are never moved, we only move the data. The constraints are required at write time surely, and mirroring creates a read-only version of the data (at which point the constraints should be enforced).
This is by design, but we are always looking for feedback on the product, so encourage you if you give your feedback here: Home (microsoft.com)
Hope this helps. Please let me know if you have any further questions.
5 Replies
Hi Anonymous
Thanks for using Fabric Community.
Mirroring replicates the 'data'. Constraints and security constructs on the tables are not moved. So just to confirm, the constraints are NOT lost, they are never moved, we only move the data. The constraints are required at write time surely, and mirroring creates a read-only version of the data (at which point the constraints should be enforced).
This is by design, but we are always looking for feedback on the product, so encourage you if you give your feedback here: Home (microsoft.com)
Hope this helps. Please let me know if you have any further questions.Hi @cfccai
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks