Aqua Data Studio's Script Generator allows the user to generate SQL Scripts for objects in a database. To generate scripts:

1. Launch the Script Generator dialog by:
   • Selecting Tools -> Script Generator from the Menu Bar OR
   • Selecting Tools -> Script Generator from the right-click pop-up menu on a database object in the Schema Browser
2. Select a Database and Schema (or All Schemas)
3. In the left panel, select one or more types of objects to be scripted.
   Click the green check button to select all and the red X button to deselect all.
4. All objects matching the selected schema & object types will appear in the right panel. Select one or more objects to be scripted.
   Click the green check button to select all and the red X button to deselect all.
5. Click Next to proceed to the Options tab
6. Specify where to save the generated scripts
   • Save as
     • One File - All SQL Statements will be output to a single file.
     • One File Per Object - SQL Statements will be output to one file per object.
     • Preview Tab - All SQL Statements will be output to the Preview tab (for copy & paste)
   • Directory / File Name - If saving as one file, select the file to receive the output. If saving as one file per object, select the directory to contain the files.
   • Encoding - Allows user to select a character encoding for files
   • Platform - Select a platform (Windows or Unix)
7. Select any appropriate options
   • Statement Separator - GO, /, ; or enter your own separator.
   • Object Quoted Identifier - none, [], "" or ''
   • Generate the CREATE - generate CREATE statements for the selected objects.
   • Generate the DROP - generate DROP statements for the selected objects.
   • Include Descriptive Header - include a header at the top of the file indicating the date, time, database, schema and names of objects contained in the file.
   • Sort By Dependencies - Output the objects in order to avoid dependency conflicts.
     e.g. if object A depends on object B, object B should be output before object A
   • Enable Identity Insert - SQL Server / Sybase only - If a table contains identity columns, place delimiting keywords to allow INSERT of data into these columns.
   • Tables: Script full table (Indexes, Triggers) - Output indexes and triggers for tables.
   • Include INSERT statements for data of Tables - Output data of Table objects as INSERT statements.
   • Qualify Objects - Fully qualify names of objects by including the Schema name.
   • Include blank line between statements - Include blank lines to improve format of output.
8. Click Next to generate the scripts for the selected objects. The output process can be halted at any point by clicking Cancel.
9. Click Close to close the dialog or click Previous to change selections and re-generate the scripts.