ExecutionBlock.ToString() Includes Entire Script Not Filtere

Brian Donahue

Hello,

Thanks for your post. It sounds like you're coding the comparison correctly. The only thing I can think of is that maybe you have the IncludeDependencies option set and the migration script is including objects that you had not selected because they need to be modified first in order to keep the script from failing.

Brian Donahue

Just as a note: also make sure that you pass the same Options enumeration to the CompareWith() method as well as the BuildFromDifferences() method that you use to generate the SQL script. If you don't, you may, for instance, compare the databases with the Include Dependent Objects option turned off, but you could generate the script with the option turned on if you are using the default set of options there!