Switch your pilot Alloy Discovery database to production
Updated in 2021.2
Take the final step of the Alloy Discovery pilot upgrade and switch your pilot database to production. This step will take the old Alloy Discovery database offline, and replace it with the fully configured pilot database.
INFO: For details, see Pilot upgrade.
To switch your pilot Alloy Discovery database to production:
-
Launch the Database Management wizard for Alloy Discovery.
-
On the Task page, select Upgrade Existing Database option and click Next. The Source Database page opens.
-
Specify the information to connect to your production (source) database.
-
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
. -
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.
-
-
Choose the name of the production (source) database from the drop-down list.
Click Next. The Upgrade Scenario page opens.
-
-
Select Pilot Upgrade and click Next. The Pilot Upgrade page opens.
-
Select the Switch to Production option and click Next. The Target Database page opens.
-
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.
-
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 Database Account page opens.
-
Specify 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. -
If the Automatic Upgrade page appears, enable the Automatic Upgrade feature.
-
Click the ellipsis button to specify the location of the most recent Alloy Discovery installation file (
AlloyDiscoverySetup24.1.x.exe
).The Turn on the Automatic Upgrade check box that was unavailable appears selected automatically.
INFO: For details, see Upgrade client components for technicians.
TIP: You can skip this step now and enable this feature later using the Settings App.
-
-
Click Next to proceed. Click Back if you need to make any changes.
-
Once the final database upgrade step completes, the Summary page opens with the information about the upgraded production database. Now you need to activate it. To start the activation, click Finish. The License Management window opens up.
INFO: For details, see Database Account.
Provide the credentials for the SQL Server account that already serves as the Database Account for the pilot database. Alternatively, click Create SQL Server Account and create a new SQLÂ Server account for this task.
Click Next. The Database Access Key page opens.
INFO: For details, see Distributing the Database Access Key.
Click Next.
Click Next. The Ready to Proceed page opens.
NEXT STEP: Activate the upgraded production database and start the production Inventory Server. For activation instructions, see Activating the product.