Installation Guide

Update your pilot Alloy Navigator data

Updated in 2021.2

You may want to update your configured pilot Alloy Navigator database with the latest data records from your production database. This will bring over all your current production data to the pilot environment. The production environment will remain fully operational and intact.

This step does not import any configuration information, only data records, so configuration changes made to your current production system after the Initial Migration will not be reflected. All data records (such as Tickets, Knowledge Base Articles, Computers, etc.) in the pilot (target) Alloy Navigator database will be replaced with the most recent data from the production (source) database.

INFO: For details, see Upgrade scenarios for Alloy Navigator.

To update your pilot data:

  1. Run the Database Management tool for Alloy Navigator.

  2. On the Task page, select Upgrade Existing Database option and click Next. The Source Database page opens.

  3. Specify the information to connect to your production (source) database.

    1. Enter the name or IP address of the SQL server where your production database resides.

      NOTE: If you are connecting to a named SQL Server instance, it must be specified in the form Servername\Instancename; for example: SQLSERV001\SQLEXPRESS. If the server uses a non-standard port, add the port number, separating it with a comma; for example, SQLSERV001\SQLEXPRESS,5618.

    2. Provide your credentials to log on to the SQL Server using an account with the sysadmin role on the SQL Server:

      • To use your Windows account, choose Windows Authentication.

      • To use your SQL Server account, choose Standard Authentication and type your account name and password.

    3. Choose the name of the production (source) database from the drop-down list.

    Click Next. The Upgrade Scenario page opens.

  4. Select Pilot Upgrade and click Next. The Pilot Upgrade page opens.

  5. Click Update Pilot Data and click Next. The Target Database page opens.

  6. Select the name of your pilot (target) database and specify where to create a backup copy of the target database.

    Click Next. The Backup Location page opens.

  7. Browse for a folder on the SQL server for the backup file and specify its file name. This upgrade step will not affect your production database, however, a backup copy is required for the process.

    Click Next. The Ready to Proceed page opens.

  8. Click Next to start updating the database.

    When the process is complete, the Database setup completed page opens.

  9. Click Finish to complete the update.

You can perform this step as many times as you need to resync your pilot data.

NEXT STEP: Stop your production system