The schema validation utility finds missing, extra, and modified schema objects for a P6 database.
To run a schema validation, complete the following steps:
@echo off
REM --------------------------------------
REM Run the Primavera Schema Validation Tool
REM --------------------------------------
SET JAR_FILE_DIR=lib
SET JAR_FILE_NAME=dbmt.jar
SET DB_SCHEMA=ppm
SET JVM_PROPERTIES=-Ddbmt.dbschema.package.location=%JAR_FILE_DIR% -Dprimavera.db.schema=%DB_SCHEMA% -Dcom.primavera.database.logfile=SchemaValidation.log
SET DBMT_ACTION=application/ppmschemaval
SET DBMT_COMMAND=schemavalpm
set JAVA_HOME=C:\Program Files\Java\jre6
IF NOT EXIST "%JAVA_HOME%\bin\java.exe" (
echo JAVA_HOME IS NOT SET
pause
goto :EXIT
)
validate.bat
(with Windows) or validate.sh
(with UNIX or Linux).With a Microsoft SQL Server database, enter values for the following:
Note: When running for an Enterprise version of the database, you will be prompted for the appropriate privileged and public usernames.
Using the Migrate Database Wizard
Running the Data Pump Utility Using the Wizard
Running the Data Pump Utility From the Command Line
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, September 30, 2016