Copying Scripts to an Export Script

To copy scripts to an export script:

On the Workspace home page, click SQL Workshop and then SQL Scripts.

The SQL Scripts page appears.
On the Tasks list, click Export.

The Export SQL Scripts page appears.
Click the check box for each of the scripts you want to export. The check boxes display on the left side adjacent to the script name. To select all displayed scripts for export, click the column head check box.
Click Add to Export to create a list of scripts to be added to the export script.

The selected scripts are added to the list of scripts in the Scripts to Export pane.
Enter a name for the export script in the File Name field.

The default script name is workspace_name_script.sql.
Click Export All to export the scripts to the export script.

You are prompted to enter the directory where you want to save the export script.

About the Scripts Pane

In the Scripts pane you can:

Search for a script. Enter a script name or partial name in the Find field and click Go. To view all scripts, leave the Find field blank, select - All Users - from the Owner list and click Go. You control how many rows display by making a selection from the Display list.
Cancel the export. Click Cancel to return to the SQL Scripts page without exporting any scripts, or to return to the SQL Scripts page after saving an export script.
Selecting scripts to export. Click Add to Export to add scripts to the export script. Scripts added to the export script are no longer listed in the Script pane, but appear in the Scripts to Export pane.
Sort scripts. Click a column heading to sort the listed scripts by that column.

In the Scripts to Export pane you can:

Rename the export script. Enter a name for the export script in the File Name field or leave the default script name.
Remove scripts. Click the check box adjacent to the scripts you want to remove f and click Remove Checked. Scripts removed are no longer listed in the Scripts to Export pane, but appear in the Scripts pane.
Save the export script. Click Export All to save the export script to your local file system. You are prompted to enter the directory where you want to save the export script.