Running the Validate Tool for a Microsoft SQL Server Database

Previous TopicNext TopicContents

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 15.1 media pack. If you run the 15.1 validate tool against your current database, it will not work.

  1. 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.

    Note: Ensure you use the validate file from your current Database folder, not the 15.1 database folder.

  2. 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.
  3. View the HTML page that the tool creates to ensure your database is not missing objects.
  4. If your database is missing objects, do one of the following:

Related Topics

Pre-Upgrade Procedures

Converting Methodologies to Projects



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library