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
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)?
- Posts: 3
- Joined: Sat Jun 01, 2013 3:04 pm
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.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 2 guests