DACExtensions contains samples that extend Data-Tier Applications using DacFx. These samples include deployment contributors and static code analysis rules that can be used with Visual Studio as well as examples of how to use the DacFx public mode
MIT License
125
stars
41
forks
source link
SchemaComparisonResult.Exclude slow for encrypted objects #30
When trying to exclude a bunch of encrypted stored procedures from a SchemaComparisonResult, the process stays hung for as long as 5s.
In my case, I have to exclude about 80 stored procedures from 15 databases, so the process of excluding objects can take several hours. This only happens when excluding encrypted stored procedures, and I'm searching for the IsEncrypted diff name.
What is happening behind the scenes when I call the Exclude method that is taking so much time?
When trying to exclude a bunch of encrypted stored procedures from a SchemaComparisonResult, the process stays hung for as long as 5s.
In my case, I have to exclude about 80 stored procedures from 15 databases, so the process of excluding objects can take several hours. This only happens when excluding encrypted stored procedures, and I'm searching for the IsEncrypted diff name.
What is happening behind the scenes when I call the Exclude method that is taking so much time?
Thank you