Page History

...

1. Use SQL Server Enterprise Manager or Management Studio to close any open connections to the Repository database.
2. 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.
3. Use a tool such as IDERA SQLsafe SQL Safe to restore the Repository database using the appropriate backup archive file.

...

Configure the Management Service so that it can communicate with the new Repository.

To configure the SQLdm SQLDM Management Service:

1. Start the Management Service Configuration wizard by selecting Start > All Programs > Idera IDERA > Idera IDERA SQL diagnostic manager Diagnostic Manager > Tools > Management Service Configuration Wizard on the computer that hosts the SQL Diagnostic Manager services.
2. Read the Welcome window, and then click Next.
3. 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
   
4. Click Test to validate your settings.
5. Click Finish to exit the wizard.

Configure the

...

SQLDM Desktop Client

Any previously deployed SQLdm SQLDM Desktop Client has to be reconfigured to connect to the new Repository.

To reconfigure the SQLdm SQLDM Desktop Client:

1. Launch the SQLdm SQLDM Desktop Client by selecting Start > All Programs > Idera IDERA > Idera IDERA SQL diagnostic manager Diagnostic Manager > SQL diagnostic managerDiagnostic Manager.
2. Click File > Connect to SQLDM Repository
3. 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
4. Click Connect to save the changes.
5. Upon connecting to the Repository database, SQL Diagnostic Manager will generate a prompt indicating that a valid license does not exist. Click Manage Licenses.
6. In the New Key section, enter the new license key that was generated for the migration and click Enter.
7. Once the key has been added successfully, click the Close button.

...

1. Open the SQL Diagnostic Manager console.
2. Enter your new SQL Diagnostic Manager license key.
3. Add the SQL Server instances you want to monitor.
4. Open the System Diagnostics utility by selecting Help > System Diagnostics.
5. Click Test.
6. Verify that all the tests are successful.
   
   

...