Data migration from a previous Reporter Server to a new one

book

Article ID: 221087

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

A new Reporter was installed with a new database and works well.

Is there a way to migrate the old Reporter Server data from its database as it's still available?

Cause

Procedure not documented

Environment

Release : 6.x

Component :Reporter Server

Resolution

There is no "transfer" command or similar available in Reporter to migrate/transfer data from one Database to another.

Reporter data from a previous Reporter Server cannot be imported as it is because the Reporter Functional Tables are all tied to the DATASOURCE_ID which is unique for each node/company/area and is stored in the table "UNI_EVT_DATASOURCES" as explained here

If you install a brand new Reporter Server and declare it in a UVMS where some nodes are residing, first time it will extract them it will obtain all the Execution Statistics, Exceptions and Audit Trail that these nodes currently have stored in their dta files according to the Retention applied on these nodes.

If it was required to add some old executions that were available in another Reporter database, you would need to probably adjust the INSERT necessary SQL commands to replace the old DATASOURCE_ID by the new one.

Nevertheless, this operation should be handled by your DBAs or Consultants, Broadcom Support does not cover database migrations.