Order of components of generated script is not preserved

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Order of components of generated script is not preserved

Postby Taras B » Tue Aug 13, 2013 4: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)?

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

Postby Brian Donahue » Fri Aug 16, 2013 10: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: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests