12.5 Server Script Generator

1. Launch the Server Script Generator dialog by:
   • Selecting Tools -> Server Script Generator from the Menu Bar OR
   • Selecting Tools -> Server Script Generator from the right-click pop-up menu on a database object in the Schema Browser
2. 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.
3. All objects matching the selected 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.
4. Click Next to proceed to the Options tab
5. 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)
6. 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.
   • 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
7. Click Next to generate the scripts for the selected objects. The output process can be halted at any point by clicking Cancel.
8. 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.