12.3 Generate SQL Scripts using ADS 7.0

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, the red X button to de-select all, or the red/green button to revert the current selection.
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, the red X button to de-select all, or the red/green button to revert the current selection.
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
   • Include Object Permissions - Now allows inclusion of DDL permissions
   • 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.
   • Overwrite Existing Script(s) - When scripting one object per file, allows to overwrite current scripts instead of generating enumerated script names
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.

Support for Permissions: Now, Script Generator tool has an option to include object permissions into DDL of the object being scripted. This option can be turned on and off by a user in the Script Generator tool dialog.

For DB2 added an option to enable/disable using specific procedure names as file names when saving procedure scripts into individual files. As DB2 can have multiple procedures with the same name, specific file names should be used together with real procedure names when naming individual script files. However, if a user is sure that there are no procedures with the same name being scripted, then he/she can use real procedure names and disable the option.