How to Migrate Log Analyzer Rules

8/23/2019 10:13 AM

8/23/2019 4:04 PM

This information details how to migrate your Log Analyzer rules from one database to another. Sometimes it is possible that you have Log Analyzer and NPM within the same server, which is not recommend. So when running configuration wizard and pointing to a new database, LA rules are not migrated. 

Use these instructions if you are migrating any LA configured rules.

Log Analyzer

1. First Backup the database.
2. Stop all LA services on the application server.
3. You can then proceed to run the script below and after script execution completes
4. Start services again. 

Please use Task/Generate Scripts functionality in SQL management studio to autogenerate insert script. Then just execute it on your new DB and you should have all of the rules data from the previous DB restored.

Warning!

• This script replaces all rules in new DB by rules migrated from old DB.

Steps

• In SQL management studio right click on LA DB you want to migrate.
  • Hover over Tasks and click on Generate Scripts... button.
  • Wizard opens
    • Go next, in choose object click on Select specific database objects. Under Tables choose dbo.OrionLog_RuleProcessingDefinitions.
    • On next screen click on Advanced button.
      • Under General section
        • Find option Script DROP or CREATE and set it to Script DROP and CREATE value.
        • Find option Types of data to script. Set it to Data only.
    • On same screen select option Save to new query window or choose file where to store generated script.
    • On next Summary screen just click next.
    • Wait on script to generate and finish the wizard.
  •  Execute generate script over your new DB where you want to migrate data.