CLI-style installation
This method allows running of the Data Model Manager entirely using command line parameters.
To install the CLI version of the Data Model Manager:
- Download the installation zip relevant to your database platform, for example, Participant Data Replication Data Model Manager for Oracle v1.0.0.zip. Replacing Oracle with your required database platform.
- Unzip the file to the desired installation folder.
- Navigate to the Lib folder and adjust the definition of the JRE environment variable in pdrDataModelManager.bat to point to a suitable JRE installation.
- You may need to set the JRE=C:\Program Files\Java\jdk-11 additional executable permissions for applying to shell scripts in Linux environments.
- You can launch the application by running the script pdrDataModelManager.bat from a terminal session with suitable command line parameters. The supported command line parameters are listed Table 31.
Command line parameters
Table 31 describes the supported parameters.
|
Parameter |
Description |
|
|---|---|---|
|
Short |
Long |
|
|
-a |
--apply |
Set this option to apply the changes to the database. If omitted the operation will stop after the script generation |
|
-d |
--database |
Oracle|SQLServer|mySQL|postgreSQL |
|
-k |
--package |
The database update package to apply |
|
-o |
--options |
The set of options to apply. Specified as a comma-delimited list. If omitted, all installation options are selected by default The options are defined within the selected Data Model Package. The standard options are: Option Applies to Create Tablespaces Create, Oracle Only Create Schema Create, Oracle Only Create Tables Create, all databases Upgrade Tables Upgrade, all database |
|
-p |
--password |
The database password |
|
-sp |
--system_password |
The database system account password |
|
-su |
--system_user |
The database system account username |
|
-t |
--tablespace_dir |
The directory to create Oracle tablespaces in |
|
-u |
--url |
The JDBC database URL. Examples: jdbc:oracle:thin:@<host>:1521:<sid> jdbc:oracle:thin:@<host>:1521/<sid> jdbc:sqlserver://<host>:1433;databaseName=<db_name>;encrypt=false jdbc:mysql://localhost:3306/<db_name> jdbc:postgresql://localhost:5432/<db_name> |
|
-w |
--working_dir |
The working directory to extract the scripts to If omitted a new folder is created matching the package filename in the same folder as the input package |
Special notes for Oracle installations only.
Understand oracle installations
Oracle installations
You may require additional database system credentials depending on your selected installation options (for example, Create Tablespace, Create Schema).
Where the Create Tablespace option is selected, an additional parameter Tablespace directory is enabled. To create the tablespaces in the associated default folder, leave this field blank.
To use an alternate folder location for Tablespace files, the Data Model Manager must run on the server hosting the database so it can create the folder.
Running the Data Model Manager with command line options examples
Creating a new oracle installation with all options enabled
pdrDataModelManager.bat --user xxxxx --password xxxxx ^
--system_user systemXXX --system_password systemXXX ^
--url jdbc:oracle:thin:@host:1521:dbName --database Oracle --apply ^
--options "Create Tablespaces,Create Schema,Create Tables" ^
--package C:\apps\DataModelManager\package\GASDM_create_v2.2.zipUpgrading an existing oracle installation
pdrDataModelManager.bat --user xxxxx --password xxxxx ^
--working_dir C:\apps\DataModelManager\package_output ^
--url jdbc:oracle:thin:@host:1521:dbName --database Oracle --apply ^
--package C:\apps\DataModelManager\package\GASDM_upgrade_v2.2.zipCreating a new SQL server installation with all options enabled
pdrDataModelManager.bat --user xxxxx --password xxxxx ^
--url jdbc:sqlserver://host:1433;databaseName=dbName;encrypt=false ^
--database SQLServer --options "Create Tables" --apply ^
--package C:\apps\DataModelManager\package\GASDM_create_v2.2.zip