Feature request: Sort objects in deployment script
When generating the sql compare deployment script - all objects are scripted in a seemingly random order.
This could be covered by an option to enable/disable it.
And obviously, there is a dependency order which much take priority first. But after that all objects should be scripted in alphabetical order.
Use case for this is generating the same update script multiple times and committing it to source control. If this is done during a RC phase, the later iterations of the script will be 90% the same with minimal differences.
Currently as it stands, objects get moved around in the output script, so when comparing scripts you cant actually tell what the true changes are - they could be identical. To diff the script you need to cut out the moved object and paste it in the old location.
Also any manual changes to the script will be difficult to identify in future scripts as well.
0 · Share on Twitter