The procedures in this section detail the migration steps for moving the SQL Diagnostic Manager Repository to a new computer while leaving the SQL Diagnostic Manager services. Follow each section in order for a successful migration.
Get a New SQL Diagnostic Manager License Key
Because you are migrating the Repository database to a different SQL Server instance, SQL Diagnostic Manager requires a new license key. You can easily request a new license key by sending an email to licensing@idera.com.
To complete the request, you need the name of the SQL Server instance where you plan to install the SQL Diagnostic Manager Repository database.
Restore the SQL Diagnostic Manager Repository on the Target Computer
To recover lost or damaged data, restore the Repository database. For best results, use the following guidelines:
- Perform a full restore
- Schedule the restore during off-hours, or times when you expect the least collection activity
To restore the Repository database:
- Use SQL Server Enterprise Manager or Management Studio to close any open connections to the Repository database.
- Use SQL Server Enterprise Manager or Management Studio to take the Repository database offline. If you cannot take the Repository database offline, stop the Collection Service.
- Use a tool such as IDERA SQL Safe to restore the Repository database using the appropriate backup archive file.
Configure the Management Service
Configure the Management Service so that it can communicate with the new Repository.
To configure the SQLDM Management Service:
- Start the Management Service Configuration wizard by selecting Start > All Programs > IDERA > IDERA SQL Diagnostic Manager > Tools > Management Service Configuration Wizard on the computer that hosts the SQL Diagnostic Manager services.
- Read the Welcome window, and then click Next.
- Verify that the following settings are correct, and then click Next.
- The name of the SQL Server instance hosting the Repository database
- The name of the Repository database
- The type of authentication the Management Service should use to connect to the Repository database - Click Test to validate your settings.
- Click Finish to exit the wizard.
Configure the SQLDM Desktop Client
Any previously deployed SQLDM Desktop Client has to be reconfigured to connect to the new Repository.
To reconfigure the SQLDM Desktop Client:
- Launch the SQLDM Desktop Client by selecting Start > All Programs > IDERA > IDERA SQL Diagnostic Manager > SQL Diagnostic Manager.
- Click File > Connect to SQLDM Repository
- Verify that the following settings are correct, and then click Next.
- The name of the SQL Server instance hosting the Repository database
- The name of the Repository database
- The type of authentication the Management Service should use to connect to the Repository database - Click Connect to save the changes.
- Upon connecting to the Repository database, SQL Diagnostic Manager will generate a prompt indicating that a valid license does not exist. Click Manage Licenses.
- In the New Key section, enter the new license key that was generated for the migration and click Enter.
- Once the key has been added successfully, click the Close button.
Verify that the Migration was Successful
The SQL Diagnostic Manager Console includes a system diagnostics test that allows you to test the connections of all the SQL Diagnostic Manager components.
- Open the SQL Diagnostic Manager console.
- Enter your new SQL Diagnostic Manager license key.
- Add the SQL Server instances you want to monitor.
- Open the System Diagnostics utility by selecting Help > System Diagnostics.
- Click Test.
- Verify that all the tests are successful.