Aqua Data Studio's Script Generator allows the user to generate SQL Scripts for objects in a database. To generate scripts:
- 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
- Select a Database and Schema (or All Schemas)
- 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.
- 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.
- Click Next to proceed to the Options tab
- 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)
- 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.
- Click Next to generate the scripts for the selected objects. The output process
can be halted at any point by clicking Cancel.
- Click Close to close the dialog or click Previous to change selections and re-generate the scripts.
Script Generator Enhancements:
-
General
-
Added an extra option to allow the overwriting of current scripts instead of generating
enumerated script names, when scripting one file per object.
-
Script Generator Dialog - Added "Reverse Selection" to object selection, to reverse the current selection.
|
|
