Multi Selection Scripting (Revision #52)

Task automation is a primary focus when choosing new features. The ability to select multiple schema objects and quickly generate DDL CREATE and DROP statements to a query window has been added to fullfil one of the most used functionalities in the application.  This also extends to multi object DROPs.  When doing a multi object operation, the user may preview the object by sorting or quick filtering through the list before starting the operation.

Multi Selection	Multi Selection Scripting Filtered	Multi Selection Scripting Results	Multi Selection Database Compare	Multi Selection Database Compare Results

Multiple Selection : Single-click solution

• Several objects can be acted upon at once using Ctrl + click or Shift + click. Right-clicking on selected objects displays new Scripting options.

Database enhancements : 3 new actions

• You can now Script, Compare and Delete multiple objects.
  
  Script Objects to Window As
      - Scripts selected objects to the current window
      - Scripts CREATE and DROP
  Script Objects to New Window As
       - Scripts selected objects to a new window
       - Scripts CREATE and DROP
  Script Objects to File As
       - Scripts selected objects to a file specified
       - Scripts CREATE and DROP
  Compare
       - Available for any 2 objects of type Server, Database or Schema
       - Performs Schema Compare operation for the selected objects
  Delete
       - Deletes selected objects

Scripting enhancements

• New Sort and Filter enhancements in Multi selection – you can now decide which objects you want to script, delete or compare.
• New options include displaying Status information, Stop on Error, Termination and appropriate Error Messages if any.

The objects to be scripted or deleted do not have to belong to the same server or be the same type of objects. If some of the objects are not scriptable (i.e. folders) they are skipped when the objects are being collected from the tree. This helps the user select multiple objects with one click without worrying about selecting the correct objects. Deletion of non-scriptable objects is not supported.

The objects to be scripted or deleted are collected into a dialog within which the user can sort and filter those objects.  Only those objects get scripted or deleted and they do so in the chosen order. If the operation is to Delete, once the user clicks OK, a prompt will appear asking whether they are sure that they want to delete the objects. Once the operation starts,  a status bar and status information is shown to allow the user to monitor the progress of the operation.  The operation can be terminated at any time by clicking on Cancel button. The user can also choose to stop the operation if an error occurs by clicking on the checkbox "Stop on Error."

If the operation is scripting, scripts for successfully scripted objects (current window, new window or file) appear in the selected destination. Successfully deleted objects are removed from the tree. The user is then able to review the results of the operation (i.e. error messages) and close the dialog.

The Compare operation compares 2 objects of type Server, Database or Schema. The 2 objects don’t have to be the same type to be compared. This operation can also be performed from Tools->Compare Tools->Schema Compare and selected those 2 nodes. If either Server node is not connected, the user is prompted to determine whether the connection should be established.

 Documentation -> Scripting