Creating the Database Schema
The database schema must be created in order for the data to be loaded. The following scenarios require data loading during a Windchill installation:
When you are creating database schema following a new Windchill installation
When you are creating database schema following the installation of an additional Windchill module
This section describes how to manually create the database schema if you opted not to allow the PTC Solution Installer to create it automatically.
Creating a database schema is done from a Windchill shell. To open a Windchill shell use one of the following commands:
UNIX or Linux
<WT_HOME>/bin/windchill --java=<JAVA_HOME>/bin/java shell
Windows
<WT_HOME>\bin\windchill.exe --java=<JAVA_HOME>\bin\java shell
Oracle
1. Load the database schema by using one of the following commands:
UNIX or Linux
For Single-Byte Character Support
windchill --javaargs="-Dwt.tools.sql.dbUser=<username> -Dwt.tools.sql.dbPassword=<password>" wt.tools.

sql.SQLCommandTool create_ddl_wt.sql <WT_HOME>/db/sql
For Multi-Byte Character Support
windchill --javaargs="-Dwt.tools.sql.dbUser=<username>

-Dwt.tools.sql.dbPassword=<password>"

wt.tools.sql.SQLCommandTool create_ddl_wt.sql <WT_HOME>/db/sql3
Windows
For Single-Byte Character Support
windchill.exe --javaargs="-Dwt.tools.sql.dbUser=<username>

-Dwt.tools.sql.dbPassword=<password>"

wt.tools.sql.SQLCommandTool create_ddl_wt.sql <WT_HOME>\db\sql
For Multi-Byte Character Support
windchill.exe --javaargs="-Dwt.tools.sql.dbUser=<username>

-Dwt.tools.sql.dbPassword=<password>"

wt.tools.sql.SQLCommandTool create_ddl_wt.sql <WT_HOME>\db\sql3
2. Load additional columns by using one of the following commands:
UNIX or Linux
windchill --jap=wt.properties\com.ptc.windchill.upgrade.tools.

upgradeframework.java.args --cpp=wt.properties\com.ptc.windchill.

upgrade.tools.classpath com.ptc.windchill.upgrade.statemachine.

DynamicLauncher -actc -noui
Windows
windchill.exe --jap=wt.properties\com.ptc.windchill.upgrade.tools.

upgradeframework.java.args --cpp=wt.properties\com.ptc.windchill.

upgrade.tools.classpath com.ptc.windchill.upgrade.statemachine.

DynamicLauncher -actc -noui
3. Initialize DBTableHashes by using one of the following commands:
UNIX or Linux
ant -f <WT_HOME>/bin/upgradeTools.xml -v populateDbHashes
Windows
ant.bat -f <WT_HOME>\bin\upgradeTools.xml -v populateDbHashes
SQL Server
1. Load the database schema by using one of the following commands:
UNIX or Linux
windchill --javaargs=”-Dwt.tools.sql.autoCommit=true

-Dwt.tools.sql.verbose=6 -Dwt.tools.sql.dbUser=<username>

-Dwt.tools.sql.dbPassword=<password>” wt.tools.sql.SQLCommandTool

create_ddl_wt.sql <WT_HOME>/db/sqlServer
Windows
windchill.exe --javaargs=”-Dwt.tools.sql.autoCommit=true

-Dwt.tools.sql.verbose=6 -Dwt.tools.sql.dbUser=<username>

-Dwt.tools.sql.dbPassword=<password>” wt.tools.sql.SQLCommandTool

create_ddl_wt.sql <WT_HOME>\db\sqlServer
2. Load additional columns by using one of the following commands::
UNIX or Linux
windchill --jap=wt.properties\com.ptc.windchill.upgrade.tools.

upgradeframework.java.args --cpp=wt.properties\com.ptc.windchill.

upgrade.tools.classpath com.ptc.windchill.upgrade.statemachine.

DynamicLauncher -actc -noui
Windows
windchill.exe --jap=wt.properties\com.ptc.windchill.upgrade.tools.

upgradeframework.java.args --cpp=wt.properties\com.ptc.windchill.

upgrade.tools.classpath com.ptc.windchill.upgrade.statemachine.

DynamicLauncher -actc -noui
3. Initialize DBTableHashes by using one of the following commands:
UNIX or Linux
ant -f <WT_HOME>/bin/upgradeTools.xml -v populateDbHashes
Windows
ant.bat -f <WT_HOME>\bin\upgradeTools.xml -v populateDbHashes
Was this helpful?