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.Generate the DROP - generate DROP statements for the selected objects.Generate the CREATE - generate CREATE statements for the selected objects.Object Quoted Identifier - none,, '' or ’’.For reuse in Aqua Data Studio, GO is the prefered separator. Statement Separator - GO, /, or enter your own separator.Options do vary based on database vendor and version. The directory and file name, encoding and platform of the file can be set. 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. Save as One File so that all SQL Statements will be output to a single file. Here in the Options Tab specify where to save the generated script or scripts. 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. The quickfilter can be used to select objects via wildcards. Select one or more objects to be scripted. All objects matching the selected schema & object types will appear in the right panel. In the left panel, select one or more types of objects to be scripted.

Select a Database and Schema (or All Schemas). 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.Ģ. The steps to Generate Schema Scripts are described in the steps below.ġ. The Schema Script Generator can also generate syntax highlighted scripts in a preview window for copy and paste. 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. Existing schema objects in the Schema Browser can be converted to DDL by the Script Generator with the Schema Script Generator. 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.

Aqua data studio 10 njot