Servigistics InService Deployment > Advanced Configurations > Database Initializing and Data Loading > Manually Creating the Database Schema
  
Manually Creating the Database Schema
If you choose not to load data using the installer, you must manually load it after the installer installs your solution using the instructions in the section Database Initializing and Data Loading. However, in certain scenarios additional steps are needed to complete your installation. These scenarios are;
• You choose to not automatically create schema and load data when installing using the installer.
• You choose to not automatically create schema and load data when adding to an existing Servigistics InService installation, using the installer.
Oracle
1. Open a Windchill shell by executing one of the following commands from a command shell:
On UNIX/Linux:
<WT_HOME>/bin/windchill --java=<JAVA_HOME>/bin/java shell
On Windows:
<WT_HOME>/bin/windchill.bat --java=<JAVA_HOME>\bin\java.exe shell
2. Load the database schema of Servigistics InService by executing the following command:
On UNIX/Linux
windchill --javaargs="-Dwt.tools.sql.dbUser=<username> -
Dwt.tools.sql.dbPassword=<password>" wt.tools.sql.SQLCommandTool create_ddl_wt.sql
<WT_HOME>/db/sql3
On Windows:
windchill.bat --javaargs="-Dwt.tools.sql.dbUser=<username> -
Dwt.tools.sql.dbPassword=<password>" wt.tools.sql.SQLCommandTool create_ddl_wt.sql
<WT_HOME>\db\sql3
3. Load the database schema of Servigistics InService Utilities by executing one of the following commands:
On UNIX/Linux:
windchill --javaargs="-Dwt.tools.sql.dbUser=<username> -
Dwt.tools.sql.dbPassword=<password> -Dwt.tools.sql.serviceName=//<hostname>:
<port>/<sid> -Dwt.tools.sql.jdbcVendor=oracle"
wt.tools.sql.SQLCommandTool create_staging_schema.sql <WT_HOME>/db/sql3/wbm
On Windows:
windchill.bat --javaargs="-Dwt.tools.sql.dbUser=<username>
-Dwt.tools.sql.dbPassword=<password> -Dwt.tools.sql.serviceName=//<hostname>:
<port>/<sid> -Dwt.tools.sql.jdbcVendor=oracle" wt.tools.sql.SQLCommandTool
create_staging_schema.sql <WT_HOME>\db\sql3\wbm
Loading e3c Schema
1. Open a Windchill shell by executing one of the following commands from a command shell:
On UNIX/Linux:
<WT_HOME>/bin/windchill --java=<JAVA_HOME>/bin/java shell
On Windows:
<WT_HOME>/bin/windchill.bat --java=<JAVA_HOME>\bin\java.exe shell
2. Load the database schema of Servigistics InService by executing the following command:
<swDir>/schemaload/ant/bin/ant -v -f <swDir>/schemaload/create3cSchema.xml
-DworkDir=<workDir> -Dhostname=<dbhost> -Dport=<dbport> -Dsid=<dbname>
-Duser_CMIDB=<cmi_username> -Duser_3CDB=<e3c_username>
-Duser_TitanDB2=<titandb2_username>
-Duser_TitanDB=<titandb_username> -Dpassword_CMIDB=<cmi_password>
-Dpassword_3CDB=<e3c_password>
-Dpassword_TitanDB2=<titandb2_password> -Dpassword_TitanDB=<titandb_password>
where, <swDir> = Location of software directory<workDir> = Location of work directory<dbhost> = Database hostname as entered in the installer during install<dbport> = Database port as entered in the installer during install<dbname> = Global Database Name (SID) or Service Name as enetered in the installer during install<cmi_username> = CMI schema username as enetered in the installer during install<e3c_username> = E3C schema username as enetered in the installer during install<titandb2_username> = TitanDB2 schema username as enetered in the installer during install<titandb_username> = TitanDB2 schema username as enetered in the installer during install<cmi_password> = CMI schema password as enetered in the installer during install<e3c_password> = E3C schema password as enetered in the installer during install <titandb2_password> = TitanDB2 schema password as enetered in the installer during install <titandb_password> = TitanDB2 schema password as enetered in the installer during install