Running the Validate Tool for a Microsoft SQL Server Database

Use the validate tool to ensure your database is not missing objects that could cause the database to fail to upgrade. You must perform the steps below before you download the latest media pack. For example, if you are attempting to upgrade to Version 24 and you run the Version 24 validate tool against a version 20 database, then the validate tool will not work.

Double-click validate.bat (validate.sh for Linux) in your current Database folder of the P6 EPPM physical media or download to start the validate tool.
Provide the following:
1. In the Database host address field, enter the server machine name or IP address where you installed Microsoft SQL Server.
2. In the Database host port field, enter the port number that Microsoft SQL Server is using. The default is 1433.
3. In the Database name field, enter the name of the existing database that you want to validate.
View the HTML page that the tool creates to ensure your database is not missing objects.
If your database is missing objects, do one of the following:
- If upgrading from 7.0, go to the 'Client Application' media pack, then locate the \install\database\scripts\ folder to find the scripts you need to fix.
- If upgrading from 8.0 or later go to the database folder of the P6 EPPM physical media or download, then locate the \database\scripts\install\ to find the scripts you need to fix.

Related Topics