Installation and Upgrade > Installation and Configuration Guide > Advanced Configurations > Database Initializing and Data Loading > Manually Loading Database Schema and Base Data
  
Manually Loading Database Schema and Base Data
During the installation using the PSI, you are prompted to select your data loader settings. If you choose not to load data using PSI, you must manually load it after PSI installs your solution.
This section describes the commands that you would use to manually load the database schema and base data for Windchill products that are installed in addition to the existing installation of Windchill. These commands must be done using a Windchill shell.
* 
Prior to loading base data for additional products ensure that HTTP Server and LDAP Server are up and running. If a Windchill solution was already installed and its related database schema was loaded, and you install an additional Windchill product on top of it, then you can load only the database schema specific to the additional Windchill product. You cannot load the same database schema twice as this will cause an error to occur.
To load database schema and base data, when additional product of PTC Windchill is installed, use the following load command syntax:
windchill --javaargs="-Dwt.tools.sql.dbUser=<username>
-Dwt.tools.sql.dbPassword=<password>"
wt.tools.sql.SQLCommandTool %WT_HOME%/db/sql/<schema file>
Note the following:
• When using an SQL server database replace all instances of %Windchill%/db/sql with %Windchill%/db/sqlServer on the Load Database Schema command.
• When using Oracle Multi-Byte Support in Windchill, replace all instances of %WT_HOME%/db/sql with %WT_HOME%/db/sql3 on the Load Database Schema command.
• %Windchill% refers to the Windchill directory.
• When loading localized base data for Windchill, replace the value of “-Locale” with locale extension applicable. For example, for Italian set to “-Locale=it“
• Replace <schema file> with the value from the following table of PTC products
• Replace <app_ID> with the value from the following table of PTC products
PTC Product
<schema file>
<app ID>
PTC Windchill
PDMLink
pdml/DDLBasic/Make_module_DDLBasic.sql
Windchill.COMMONPDM
Windchill.PDMLink
PTC Windchill
ProjectLink
pjl/ChangePlanning/Make_module_ChangePlanning.sql
pjl/ProjectManagement/Make_module_ProjectManagement.sql
Windchill.ProjectLink
PTC Windchill
QMS
qms/Masterdata/Make_module_Masterdata.sql
Windchill.QualityManagement.QMS
PTC Windchill
CAPA
capa/CAPA/Make_module_CAPA.sql
Windchill.QualityManagement.CAPA
PTC Windchill
Nonconformance
nc/NC/Make_module_NC.sql
qms/DispositionServer/Make_module_DispositionServer.sql
Windchill.QualityManagement.NC
PTC Windchill Customer Experience
Management
cem/CEM/Make_module_CEM.sql
Windchill.QualityManagement.CEM
PTC Windchill UDI
udi/UDI/Make_module_UDI.sql
Windchill.QualityManagement.UDI
PTC Windchill Integrations for Embedded Software
rialto/WTSoftwareIssue/Make_module_WTSoftwareIssue.sql
Windchill.SoftwareLink.Installed
PTC Arbortext Content Manager
pdml/DDLBasic/Make_module_DDLBasic.sql
Windchill.COMMONPDM
PTC Windchill ESI Services
esi/Esi/Make_module_Esi.sql
Windchill.EnterpriseSystemsIntegration
PTC Windchill Product Analytics
Process Adapter
wii/Environment/Make_module_Environment.sql
Windchill.Environment
PTC Windchill Gateway for Cadence Allegro Design Workbench (ADW)
N/A
Windchill.ECADLibSyncServer
PTC Windchill Ship
Building Template
N/A
Windchill.WCShipbuildingTemplate
PTC Windchill Supplier Management
suma/SupplierManagement/Make_module_SupplierManagement.sql
Windchill.SupplierManagement
PTC Windchill Aerospace and Defense - CDRL/SDRL, CAGE Code and Unincorporated Charge
wadm/wadm/Make_module_wadm.sql
Windchill.WADM
PTC Windchill Aerospace and Defense - Configuration Items and Design Solutions
N/A
Windchill.ConfigItemDesignSolution
PTC Windchill Aerospace and Defense - Setup for Configuration Items and Design Solutions
N/A
Windchill.ConfigItemDesignSolution_InstallConfig
PTC Windchill PartsLink
N/A
Windchill.PartsLink
PTC Windchill Service Information Manager
sis/SisCore/Make_module_SisCore.sql
Windchill.SIS
PTC Windchill Service Part
sisipc/PartList/Make_module_PartList.sql
Windchill.SISPartCatalog
PTC Windchill
MPMLink
/sql/mpml/MPMLink/Make_module_MPMLink.sql
Windchill.mpmlink