How to set IgnoreSystemNamedConstraintNames option in Visual Studio 2019 SCA extension

ThomasHThomasH JohannesburgPosts: 7 Bronze 1
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 
Tagged:

Best Answer

  • Sergio RSergio R Posts: 609 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools

Answers

  • ThomasHThomasH JohannesburgPosts: 7 Bronze 1
    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
Sign In or Register to comment.