Options
How to set IgnoreSystemNamedConstraintNames option in Visual Studio 2019 SCA extension
ThomasH
Posts: 9 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
I also need to ignore Sequence START WITH value from comparisons.
Can somebody assist me?
Regards
Tagged:
Best Answer
-
OptionsSergio R
Posts: 610 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-optionsUnsupported 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
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