How can we help you today? How can we help you today?

How to set IgnoreSystemNamedConstraintNames option in Visual Studio 2019 SCA extension

After creating the project SCA identifies all the system named constraints as differences and then creates a migration script for these differences. 

I also need to ignore Sequence START WITH value from comparisons.

Can somebody assist me?

Regards
ThomasH
0

Comments

2 comments

Sort by
  • Sergio R
    Hi Thomas,

    This option is not supported in SCA for VS:

    https://documentation.red-gate.com/sca/developing-databases/concepts/advanced-concepts/comparison-and-script-generation-options

    Unsupported options

    Options that are "locked" to ensure deployment reliability

    A number of SQL Compare options would, if switched on, cause scripts to be generated that might not work within all of your target environments. In order to ensure that a given migration can be successfully executed against all of your databases, there are a number of options that are locked to the Off setting:

    • Ignore constraint names
    • Ignore system-named constraint names
    • Ignore DML trigger order
    • Ignore certificates, symmetric keys and asymmetric keys
    • Ignore check constraints
    • Ignore foreign keys
    • Ignore identity properties
    • Ignore nullability of columns
    • (Data Compare) Ignore underscores in object names
    • (Data Compare) Ignore spaces in object names
    • (Data Compare) Include indexed views
    • (Data Compare) Exclude identity columns
    Sergio R
    0
  • ThomasH
    Thanks Sergio  :)

    That means I will have to follow best practice and add a name to each default constraint. I was just hoping to avoid doing it for a proof of concept that I am busy with.

    Regards

    Thomas
    ThomasH
    0

Add comment

Please sign in to leave a comment.