Select the Generate table creation scripts command from the Extracts menu. The Generate Creation Scripts dialog, shown in the following image, is then displayed.
On a primary, the Change button in the Mapping group box is enabled so that you can select another schema, RPS mapping, and database name defined in that schema or another RPS mapping in the displayed schema, if required.
If you want to generate creation scripts for selected tables only, in the Tables group box, select the Selected option button and click the Select button that is then enabled.
The RPS Table Selection dialog is then displayed. For details, see "Selecting Tables", earlier in this chapter.
In the Script File Name text box, specify the full path and name of the file to which your creation script is generated. The directory must be valid on the server. If it does not exist, it is created. Alternatively, click the adjacent Browse button to display the common Browse for Folder dialog that enables the selection of the directory in which the creation script is generated.
If you want an existing creation script overwritten, check the Allow Overwrite check box. As creation scripts are not overwritten by default, the generation of the creation script fails if a file exists in the output directory.
Click the OK button. Alternatively, click the Cancel button to abandon your selections.
