ExecutionBlock.ToString() Includes Entire Script Not Filtere

Brian DonahueBrian Donahue Posts: 6,590 New member
edited October 4, 2005 5:22AM in SQL Toolkit Previous Versions
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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!
This discussion has been closed.