Generating scripts

Select at least one object in the grid before selecting > Generate Scripts. You can also generate scripts for all objects.

After selecting Generate Scripts to validate the object status, the Generate Script dialog is displayed. Select Output File Style.

If the output file style is SQL Scripts Organized by Table, then scripts files are generated for each table related to respective selected object(s) in the Single-Tenant Output folder.
If the output file style is SQL Scripts Organized by Object Type, only one script file is generated to the selected object(s) in the Single-Tenant Output folder.
Single-Tenant Output folder path is read from the BDL.SHAREDPATH profile attribute. While generating the scripts, a sequence script file is also generated for the required object(s).

After the scripts are generated in the output folder, a Generate Scripts Success alert is displayed. The Script Generation Status and Date columns are updated in Main tab grid. Otherwise, a message with the reason for the error is displayed.

Note:

The status of the selected object can be identified based on colour code for the Status field in the respective grid.