Migration path from legacy to enhanced MCS Profiles sqlserver

Products

• NIMSOFT PROBES
• DX Infrastructure Management

Issue/Introduction

We are upgrading our UIM 8.5 env to 9.2.0 and also wish to make use of the latest MCS enhanced profile for sqlserver

What is correct migration path for this?

Environment

Release : 9.2.0

Component : UIM - MON_CONFIG_SERVICE

Resolution

Existing sqlserver MCS template version = 2.21

Steps

1. complete upgrade to UIM 9.2.0
2. download sqlserver probe 5.42 to archive
3. download 1578407039313_sqlserver_mcs_templates 5.33.zip from this document
4. rename to sqlserver_mcs_templates 5.33.zip
5. import sqlserver_mcs_templates 5.33.zip to archive
6. deploy sqlserver_mcs_templates 5.33 to primary hub
7. activate template package as per Migrating and Converting Existing Profiles
   • use the following parameters when activating the template
     • probe_name : sqlserver
     • template_package_version:  5.33-SNAPSHOT
   • Note: With this step, the template SQL Server will be migrated to legacy version 2.24

8. Delete the Existing 5.31 mcs template package from db with below queries run in sequence not parallel

   
   
   DELETE
     FROM [CA_UIM].[dbo].[SSRV2ProbeTemplatesPackage]
     where probe_name = 'sqlserver'
     and probe_template_pkg_version = '5.31'
   
   
   DELETE
     FROM [CA_UIM].[dbo].[SSRV2ProbeTemplateUpgrade]
     where probe_name = 'sqlserver'
     and probe_template_pkg_version = '5.31'
   
   
9. Verify that setup SQLServer profile is in UMP. If not create it
10. Enhance the legacy profile as per Migrating and Converting Existing Profiles
    • This will migrate the 2.24 legacy SQL Server profile to SQL Server Enhanced 5.30.9
11. download 1578407051775_sqlserver_mcs_templates 5.43.zip from this document
12. rename to sqlserver_mcs_templates 5.43.zip
13. Import sqlserver_mcs_templates 5.43.zip into archive
14. deploy sqlserver_mcs_templates 5.43 to primary hub
15. activate template package as per Migrating and Converting Existing Profiles
    • use the following parameters when activating the template
      • probe_name : sqlserver
      • template_package_version:  5.43-SNAPSHOT
16. Enhance the setup SQLServer profile as per Migrating and Converting Existing Profiles
    • This will migrate the SQLServer profile to the latest enhanced version 5.43