Order of components of generated script is not preserved

Forum for users of SQL Compare schema synchronization utility

Order of components of generated script is not preserved

Postby Taras B » Tue Aug 13, 2013 3:36 pm

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)?

Taras B
Posts: 3
Joined: Sat Jun 01, 2013 2:04 pm

Postby Brian Donahue » Fri Aug 16, 2013 9:28 am

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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests