Upgrade the Production Alloy Discovery Database

This final migration step will import all data from your production Alloy Discovery database to a new Alloy Discovery 8 database again, take the old Alloy Discovery database offline, and replace it with the newly created Alloy Discovery 8 database. If you are upgrading from version 7.2 or later, this step will turn on automatic client upgrades.

INFO: For details, see Database Migration for Alloy Discovery.

  1. On the Welcome page of the Database Management tool for Alloy Discovery, click Next to continue.
  2. Click Migrate inventory data from a previous version of Alloy Discovery or Alloy Navigator and click Next. The Choose the source product version page opens.
  3. Select the Alloy Discovery 6 or 7 database option and click Next. The Choose the migration mode page opens.
  4. Select the Upgrade the production database option and click Next. The Choose the source database page opens.
  5. Specify the following settings:
    1. Enter the name or IP address of the SQL server where both production and test databases reside.
    2. Provide your credentials to log in to the SQL Server using an account with the sysadmin role on the SQL Server.
    3. Choose the name of the source Alloy Discovery 6 or 7 database from the Source DB drop-down list.

    Click Next.

  6. On the Back up the source [Product Name and Version] database page, browse for a folder on the SQL server for the backup file and specify its file name. Click Next. The Database Account page opens.
  7. Specify the Database Account.
  8. IMPORTANT: For details, see Database Account.

    Provide the credentials for the SQL Server login that already serves as as the Database Account for the pilot database. Alternatively, click Create SQL Server Account and create a new SQL Server login for this task.

    Click Next. The Database Access Key page opens.

  9. Once you specified the Database Account, the Database Management tool generates a Database Access Key. By default, the key is exported into the [KeyName].reg file on your desktop. To change the default path or name, click the ellipsis button and specify a new location.
  10. INFO: For details, see Distributing the Database Access Key.

    Click Next. The Automatic Upgrade page opens.

  11. Optional: On this page you can enable the Automatic Upgrade feature. For details, see Automatically Upgrade Alloy Discovery 7 Client Components for Technicians
  12. NOTE: You can skip this step now and enable this feature later using the Settings app.

    IMPORTANT: The Automatic Upgrade feature works only for upgrades from version 7.2 or later.

    1. Click the ellipsis button to specify the location of the latest Alloy Discovery8 installation file (AlloyDiscoverySetup87x.exe).
    2. The Turn on the Automatic Upgrade check box that was unavailable appears selected automatically.

    Click Next.

  13. On the Ready to proceed page, click Next to proceed. Click Back if you need to make any changes.
  14. Once the database has been created, the Summary page opens with the information about the newly created database. Now you need to activate the new database. To start the activation, click Finish. The License Management window opens.

The task to import inventory data from the source database is queued in Alloy Discovery 8. Once you have activated Alloy Discovery 8 and started the Inventory Server 8, the server will import the data to the new Alloy Discovery 8 database.