Options

Order of components of generated script is not preserved

Taras BTaras B Posts: 4
edited August 16, 2013 5:28AM in SQL Compare Previous Versions
We are generating rollout scripts with SQLCompare command line tool. Being able to compare generated script between 2 builds will be very useful to understand changes, but this is rather impossible due to heavy re-ordering of the components of the rollout script. Is there any way to ensure certain ordering of the entries (e.g. dependency driven + alphabetic)?

Thanks
Taras
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Taras,

    SQL Compare works out the dependency matrix and that determines the order of the script generation. If the database changes, the order in which objects are created or altered could be vastly different.

    SQL Compare can output a report in HTML format that can show the changes, if that is of any use.
    · Share on Twitter
Sign In or Register to comment.