Generating Table Creation SQL Scripts
From the primary or RPS node secondary, generate the script file that creates tables and stored procedures in the target relational database that are required for your RPS mapping. (For details about programmatically generating a script that generates the tables for an RPS mapping, see the
To generate table creation scripts
-
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.
The Jade RPS Manager window displays the progress of the creation script generation process and its completion. The tables and stored procedures for the selected RPS mapping are then created in the specified file (for example, c:\jade\Rps\tableDefn_DocExample.sql).
