Use the Database Upgrade Wizard to Create an Upgrade Script for a MineMarket Database

Use this activity to create an upgrade script for a specific MineMarket database using the MineMarket Database Upgrade Wizard.

Important: This activity presumes that a database for MineMarket 4.6.62 or later exists on the Database Server.

Activity Steps

  1. Close all MineMarket applications.
  2. Stop all MineMarket services.
  3. Close all connections to the MineMarket database.
  4. Back up the MineMarket database.
  5. Perform one of the following steps:
    1. Start the MineMarket Database Upgrade Wizard as a stand-alone program:
      1. Navigate to the MineMarket Server installation folder.
      2. Run MineMarket.UpgradeWizard.exe.

        Note: Only use the stand-alone program from a MineMarket installation that has already been upgraded to the required version.

    2. Start the MineMarket Database Upgrade Wizard from the MineMarket setup wizard:
      1. Run the setup file in the MineMarket installation package.

        The setup wizard displays.

      2. Click Next.

        Note: The MineMarket setup wizard checks whether some prerequisite components (for example, for Crystal Reports) are installed. If these prerequisite components are not already installed, the MineMarket setup wizard opens a separate installation for them. Follow the prompts if required or contact your System Administrator for assistance.

      3. Click Run Database Upgrade Wizard.

    The MineMarket Database Upgrade Wizard opens and displays the Upgrade Mode Selection screen.

  6. Select Connect to an existing MineMarket database; generate an upgrade script; but do not run the script against the database.
  7. Click Next.

    The Checklist screen displays the prerequisite steps.

  8. Check I acknowledge this checklist. I have performed the necessary steps, including backing up the MineMarket database.
  9. Click Next.

    The Folder Selection screen displays. The MineMarket installation folder is selected by default so the MineMarket Database Upgrade Wizard can read database connection details from the ServerSettings.xml file.

  10. Click Next.

    The Database Selection screen displays.

  11. If the database connection details have not been read from the ServerSettings.xml file:
    1. Select whether the Database Type is SQLServerNative or OracleODP.

      Note: If using Oracle, the Oracle 12c Client, also known as Oracle Data Access Components (ODAC), to match the version of Oracle on the Database Server, must be installed on the machine running the Database Upgrade Wizard.

      If using Oracle, ensure that TNS_ADMIN has been added to the environment If using Oracle, ensure that TNS_ADMIN has been added to the environment variables:

      1. From the Start Menu, right-click Computer and select Properties. The System screen opens.
      2. Select Advanced system settings. The System Properties screen opens.
        3. On the Advanced tab, click Environment Variables. The Environment Variables screen opens.
      3. Create a new system variable with the variable name TNS_ADMIN. Set the variable value to the folder path of the tnsnames.ora file (for example, C:\\[path]\network\admin). Enter tnsping [listener name] at the command prompt to identify the folder path if required.
    2. If the Database Type is SQLServerNative,
      1. Enter the Server Name.
      2. Enter or select the Database Name.
    3. If the Database Type is OracleODP, enter the TNS Name.
    4. Select whether to Use Windows Integrated Security.
    5. If Use Windows Integrated Security is unchecked, enter the User ID and Password.
  12. To test the database connection details, click Test Connection.
  13. Click Next.

    The MineMarket Database Upgrade Wizard connects to the database and queries it to determine the current version of the database.

    The Database Version screen displays the results of the query and a summary of the database details.

  14. Click Next.

    The Summary screen displays a summary of the actions to be taken.

  15. Click Next.

    The MineMarket Database Upgrade Wizard generates the upgrade script.

  16. If the script generation was successful, the Script Generation Successful screen displays the upgrade script.
    1. To copy the upgrade script to the clipboard, click Copy to Clipboard.
    2. To save the upgrade script as a file, click Save to File.
    3. Click Finish.

      The MineMarket Database Upgrade Wizard closes.

  17. If the script generation was not successful, the Errors Were Encountered screen displays the errors.
    1. Click Finish.

      The MineMarket Database Upgrade Wizard closes.

    2. Contact your Datamine representative for assistance with a customised upgrade script.
  18. Exit the MineMarket setup wizard if applicable.