6.12 Exporting and Importing SQL Scripts

Move scripts from your current Script Repository by exporting them and then importing SQL Script Export into a Script Repository in a different workspace.

• Exporting SQL Scripts
  Move scripts from your current Script Repository by exporting them.
• Importing Scripts
  Import a Script Export into the Script Repository.

6.12.1 Exporting SQL Scripts

Move scripts from your current Script Repository by exporting them.

By default, the Export SQL Scripts page lists all scripts in the Script Repository created by the current user. Export SQL Scripts features two regions: Scripts and Scripts to Export. Use Scripts to select the scripts to export. Then, review Scripts to Export to finalize the scripts to export and choose a name for the Script Export.

To export script files:

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

   The SQL Scripts page appears.

2. On the Tasks list, click Export.
   The Export SQL Scripts page appears.
3. Under Scripts:
   1. Select the scripts you want to export. To select all displayed scripts, click the column head check box.
   2. Click Add to Export.
   
   Description of the illustration sql_s_pane.png

   The selected scripts display under Scripts to Export.

4. Under Scripts to Export:
   1. File Name - Enter a name for the export script. The default script name is workspace_name_script.sql.
   2. To remove a script, deselect it and click Remove Checked.
   3. Click Export All.
5. Import the Script Export.

6.12.2 Importing Scripts

Import a Script Export into the Script Repository.

To import scripts:

1. Sign in to the target workspace.
2. On the Workspace home page, click SQL Workshop and then SQL Scripts.

   The SQL Scripts page appears.

3. On the Tasks list, click Import.
   The Export SQL Scripts page appears.
4. On Import Scripts:
   1. Import file - Browse to the Script Export you want to import.
   2. File Character Set - Indicate the character set encoding of the file to be imported.
   3. Click Next.
   The Import Scripts page appears. The Action column indicates whether the imported script is new, or whether it replaces an existing script of the same name.
5. Click Import Script(s) to import the listed scripts into the current Script Repository.
   The SQL Scripts page appears listing the imported scripts.