Schema Script Changes from Version 5

Single Script

The biggest change between version 5 and 6 is version 6 now generates a single script of all checked objects to update instead of generating a single script per object. 

Why a Single Script ?

Version 5 performed some dependency analysis and ordered the various objects into an order that generated a reliable script however there were instances where the ordering was inadequate and the script required multiple executions. Whilst this was fine within SQL Delta, in fact SQL Delta was designed to allow multiple executions, this was not so successful if the script was saved and then later executed since it could not be executed multiple times. 

Auto Dependency

In version 6 objects are better sorted and even auto added to the script to improve the quality of the sync script. This auto dependency does introduce some changes in the behavior of SQL Delta 6 where in version 5 creating a subset of updates generally created a script that only changed the selected objects and now in version 6 dependent objects are included in the script to ensure it is successful. In some cases this may include object drops. While version 6 provides two mechanisms to prevent automatic changes to the script, No Depend and Allow Drop buttons respectively stop any auto dependent action and stop and automatic drops from scripting this is a change in traditional behavior of SQL Delta.

Editable Script

The script is now editable and while in general the script does not need editing it could be changed to add user defined comments to sections of the script, ready for saving or adding to the target.

Alerts

A large number of alerts have been added to SQL Delta 6 to notify you of when significant data changing actions will take place when the sync script is deployed.