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, object CREATE and object DROP can be accomplished for multiple selected items and scripted to the query window or to a file.
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 select objects to the current window, it also scripts CREATE and DROP. Script Objects to New Window As scripts select objects to a new window, it also scripts CREATE and DROP. Script Objects to File As scripts selected objects to a file specified and can script CREATE and DROP. Compare is available for any two objects of type Server, Database, or Schema and performs a Schema Compare operation (See the Compare Tools section for more on Comparison Tools in Aqua Data Studio) for the selected objects. Delete deletes selected objects.
Scripting Filter and Status
Sort and Filter in Multi selection allow selection of which objects need to be scripted, deleted, or compared. When two objects are selected for scripting the resulting window allows for quick filtering of their contained schema objects, further refining which two objects are acted on. Options include displaying Status information, Stop on Error, Termination, and appropriate Error Messages if any are generated.
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 Schema Browser.
- Connect to the Server (giving username and password for authorization if needed).
- 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. (See the Compare Tools section for more on Comparison Tools in Aqua Data Studio)
- Locate the Servers in the Schema Browser.
- Press CTRL and select the two schema objects you want to Compare within those servers.
- A popup appears, click on Compare.
- If you have not 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 dialog 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 Schema Browser.
- Connect to the Server (giving username and password for authorization if needed).
- 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 Schema Browser.
- Connect to the Server (giving username and password for authorization if needed).
- 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 object. 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 in selecting 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 Cancel. 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 two objects of type Server, Database or Schema. The two objects do not have to be the same type to be compared. This operation can also be performed from Tools > Compare Tools > Schema Compare and select those two nodes. If either Server node is not connected, the user is prompted to determine whether the connection should be established.
