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?
Release : 9.2.0
Component : UIM - MON_CONFIG_SERVICE
Existing sqlserver MCS template version = 2.21
Steps
- complete upgrade to UIM 9.2.0
- download sqlserver probe 5.42 to archive
- download 1578407039313_sqlserver_mcs_templates 5.33.zip from this document
- rename to sqlserver_mcs_templates 5.33.zip
- import sqlserver_mcs_templates 5.33.zip to archive
- deploy sqlserver_mcs_templates 5.33 to primary hub
- 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
Delete the Existing 5.31 mcs template package from db with below queries run in sequence not parallel
DELETEFROM [CA_UIM].[dbo].[SSRV2ProbeTemplatesPackage]where probe_name = 'sqlserver'and probe_template_pkg_version = '5.31'
DELETEFROM [CA_UIM].[dbo].[SSRV2ProbeTemplateUpgrade]where probe_name = 'sqlserver'and probe_template_pkg_version = '5.31'- Verify that setup SQLServer profile is in UMP. If not create it
- 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
- download 1578407051775_sqlserver_mcs_templates 5.43.zip from this document
- rename to sqlserver_mcs_templates 5.43.zip
- Import sqlserver_mcs_templates 5.43.zip into archive
- deploy sqlserver_mcs_templates 5.43 to primary hub
- 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
- 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