Skip running in shadow database

I have a table where end users can insert records, and development needs to insert records via scripts.
If we add them as a migration script, then they fail on the shadow database due to FK constraints.
Our developers use SQL Clone, so everyone would have the FK related records.
Is there a way to mark migration scripts so they don't get run in the shadow database?

Sean_Lively August 22, 2024 04:16

Comments

1 comment

Hi @Sean_Lively

Unfortunately, it's not possible to skip the shadow database verification step entirely, however, you can exclude specific objects: https://documentation.red-gate.com/sca/developing-databases/concepts/verifying-projects/excluding-objects-from-script-verification

DanC August 27, 2024 11:24

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Skip running in shadow database

Comments

Add comment