Clear all

Sql Server Referential Integrity

Posts: 0
Topic starter
Joined: 52 years ago

Whenever building a DV on Oracle, the FK constraints are being disabled when loading into the Raw Vault (and materialised Business Vault entities) and being enabled after for better performance querying the DV.

AFAIK, Sql Server doesn't have the possibility to disable constraints, but one can set up FKs with NOCHECK option (soft RI). Would this be a viable option?

1 Reply