11.8 Multi Scripting Objects (Revision #27)

Aqua Data Studio allows taking action on multiple items in the Schema Browser at the same time, including scripting, with a right click. Schema Comparisons, object DELETE, table DELETE, table CREATE and table DROP can be accomplished for multiple selected items and scripted to the query window or to a file.

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 Scripting options.

Database Scripting on Multiple Objects

• It is possible to 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 (See the Compare Tools section for more on Comparison Tools in Aqua Data Studio)
       - Available for any 2 objects of type Server, Database or Schema
       - Performs Schema Compare operation for the selected objects
• Delete
       - Deletes selected objects

Scripting Filter and Status:

• Sort and Filter in Multi selection – decide which objects need to be scripted, deleted or compared.
• 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.

1. Locate the Server in the Schema Browser.
2. Connect to the Server by giving username and password for authorization.
3. Click and Expand the Item which displays Schema.
4. Press CTRL and select all the schema object you want to script.
5. Right-click on the Server node and a popup with information to Script is displayed.
6. 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. (See the Compare Tools section for more on Comparison Tools in Aqua Data Studio)

1. Locate the Servers in the Schema Browser.
2. Press CTRL and select the two schema objects you want to Compare.
3. A popup appears and click on Compare.
4. If you haven't 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.
5. Once connected you can select the database objects to Compare.
6. 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.

1. Locate the Server in the Schema Browser.
2. Connect to the Server by giving username and password for authorization.
3. Click and Expand the Item which displays Table.
4. Press CTRL and select all the Table objects you want to script.
5. Right-click on the Server node and a popup with information to Script is displayed.
6. 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 .

1. Locate the Server in the Schema Browser.
2. Connect to the Server by giving username and password for authorization.
3. Click and Expand the Item which displays Table.
4. Press CTRL and select all the schema object you want to Drop.
5. Right-click on the Server node and a popup with information to Script is displayed.
6. 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.