How to set IgnoreSystemNamedConstraintNames option in Visual Studio 2019 SCA extension

ThomasH

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 

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

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