Skip to Content

Is there a way to turn off the Domain Divergence warning for migrated PK fields?

Hi,

SQL server 2012 physical model and I use identity PK fields that have with a domain called Id with the Identity checkbox selected.

Let's say I have a table, Table1, PKF1 its PK field with the domain Id and a second table, Table2. When I add an one-to-many FK from Table1 to Table2, PKF1 is migrated to Table2. When I generate the script I get Domain Divergence warnings because the identity property is dropped (which makes sense).

Is there a way to turn this specific warning off (because it is really noise)?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 16 at 09:15 AM

    You can turn off individual model checks each time you generate a script. I believe you can also disable a model check using a script, but you'd need to check the metamodel objects help.

    Add comment
    10|10000 characters needed characters exceeded