11.2 Multi Scripting Objects

Application - Visual Editing

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 available with the latest release of Aqua Data Studio.

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 with ADS version 7.0

• 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.

How to Multi-Select and Script Schemas - Here we describe how to Multi-select and Script Schemas in Apache Derby. You can select CREATE Schema or DROP Schema.

• Locate the Server in the Server Browser.
• Connect to the Server by giving username and password for authorization.
• Click and Expand the Item which displays Schema.
• Press CTRL and select all the schema object you want to script.
• Right-click on the Server node and a popup with information to Script is displayed.
• Select the necessary action - Script to CREATE / DROP or DELETE.

How to Multi-Select and Compare Schemas - Here we describe how to Multi-select and Compare two Schemas.

• Locate the Servers in the Server Browser.
• Press CTRL and select the two schema objects you want to Compare.
• A popup appears and click on Compare.
• If you havent Connected to the Server, you will be prompted to Connect. Press Yes. If ADS fails to Connect to any of the Servers, Failed to Connect dailog will appear. Check the connection and try Comparing again.
• Once connected you can select the database objects to Compare.
• The result of the Compare will be displayed as a List, which you can save as HTML.

How to Multi-Select and Script Tables - Here we describe how to Multi-select and Script Tables in a Server. You can select CREATE table or DROP table.

• Locate the Server in the Server Browser.
• Connect to the Server by giving username and password for authorization.
• Click and Expand the Item which displays Table.
• Press CTRL and select all the Table objects you want to script.
• Right-click on the Server node and a popup with information to Script is displayed.
• Select the necessary action - Script Table to CREATE / DROP to New window or File.

How to Multi-Select and DELETE Tables - Here we describe how to Multi-select and delete Tables in a Server. You will be prompted before you can DROP tables .

• Locate the Server in the Server Browser.
• Connect to the Server by giving username and password for authorization.
• Click and Expand the Item which displays Table.
• Press CTRL and select all the schema object you want to Drop.
• Right-click on the Server node and a popup with information to Script is displayed.
• Select the - DELETE.

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.