Multiple Selection Scripting (Revision #74)

One of the most useful enhancements in Aqua Data Studio 7 is the ability to select multiple schema objects and quickly generate DDL CREATE and DROP statements to a query window. This feature even extends to multi-object DROPs. You can also preview multi-selected objects and sort or quick filter through the list before executing the operation.

Taking advantage of Multiple Selection Scripting

Multi Selection

Use Ctrl + click or Shift + click to select multiple objects; then right-click to display the new scripting options.

For database schema objects, you can:

• Script – Script both CREATE and DROP to the current window, a new window, or a file you specify. Screenshot of Script Scripting Results

  Multi Selection Scripting Results

• Compare – Perform the Compare operation for any two Server, Database or Schema objects.

  Multi Selection Database Compare	Multi Selection Database Compare Results

• Delete – Deletes all the selected objects at once.

Multi Selection Database Compare Filters

Multi-selection is even more useful with quick filtering and sorting. Objects to be scripted or deleted are collected into a convenient dialog box where you can sort and filter to refine your selection so that only those objects are scripted or deleted. There are also new options to display Status information, Stop on Error, Termination and Error Messages (if any).