How can I generate the SQL files required to create the database schema?
Generating the SQL files for the database schema
If you do not have the access rights to generate the schema in the database, you can create the required SQL files and then provide them to the database administrator. If you do have the access rights to generate the schema in the database, you might also want to generate the SQL files and review them before applying them to the database.
Proceed as follows:
- Browse to the folder containing the configureDb command. The command is
located in the following path, depending on the component for which you are installing:
- master domain manager
- image_location/TWS/interp_name
- Dynamic Workload Console
- image_location
- When launching the configureDb command on the workstation where you plan to
install the master domain manager or Dynamic Workload Console, as explained in Creating and populating the database, set – execsql parameter
set to false:
- -execsql|-es execute_sql
- Set to true to generate and run the SQL file, set to false to generate the SQL statement without running it. The resulting files are stored in the path defined in the work_dir parameter. This option is useful if you wan to review the file before running it. This parameter is optional. The default value is true.
- The command creates the relevant SQL scripts containing the settings you have defined in the command line. The files are created in the working directory, which by default is /tmp on UNIX operating systems and C:\tmp on Windows operating systems.
For more information about the configureDb command, see Database configuration - configureDB script.