Migration path from legacy to enhanced MCS Profiles sqlserver

book

Article ID: 142644

calendar_today

Updated On:

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

Attachments

1578407051775__sqlserver_mcs_templates 5.43.zip get_app
1578407039313__sqlserver_mcs_templates 5.33.zip get_app