Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio’s Schema Script Generator generates SQL Scripts for schema objects in a database by producing a single file or files per object. Existing schema objects in the Schema Browser can be converted to DDL by the Script Generator with the Schema Script Generator.
The Schema Script Generator differs from the Server Script Generator in that Schema Scripts are for schema objects such as tables and procedures, while Server Scripts are for database management of server objects like backups, alerts, logins, roles and tabelspaces.
The Schema Script Generator can also generate syntax highlighted scripts in a preview window for copy and paste. The steps to Generate Schema Scripts are described in the steps below.
1. Launch the Script Generator dialog by Selecting Tools->Script Generator from the Menu Bar 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). 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. All objects matching the selected schema & object types will appear in the right panel. Select one or more objects to be scripted. The quickfilter can be used to select objects via wildcards. 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. Click Next.
3. Here in the Options Tab specify where to save the generated script or scripts. Save as One File so that all SQL Statements will be output to a single file. Save as One File Per Object so that SQL statements will be output to one file per object, or Preview the SQL so that all the SQL statements will be output to the Preview tab for copy and paste. The directory and file name, encoding and platform of the file can be set. Options do vary based on database vendor and version. Select any appropriate options for:
4. Click Next to generate the scripts for the selected objects. The Status tab displays any warnings or messages as the export progresses. The output process can be halted at any point by clicking Cancel.
5. If Preview was selected as the destination of the export, the Preview Tab displays the export with syntax highlighting for copy and paste use.
Click Close to close the dialog or click Previous to change selections and regenerate the script(s).