question

Vandana R. avatar image
Vandana R. asked ·

Restoring older CAS and ADS data to a newer version

Hello Team,

We are going to restore the CAS and ADS data from last year (Jan-april 2017). Here are some of the questions for which we need your expert advice.

  • 1)Do you think restoring old version (say 12.2 or 12.4) ADC and CAS data will succeed on newer version (say 2017) ? Any compatibility matrix to refer to show how much upward/backward compatible the data is?
  • 2)Once the Data is restored .Is there a query to find out to which version the data belongs to? We are asking this because at the moment we are not sure the backup copy which DB guys have is from what version of CAS and ADC.
  • 3)After restoration of data is there any config change which needs to be made for the data to be accessible for reporting.
nam serverads
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Answer

Chris V. avatar image
Chris V. answered ·

Vandana, are you talking about restoring an old database? or replaying old zdata files?

Assuming you mean the database, the database version is stored in the configuration table, so you can examine that with SQL Management Studio before running up the CAS/ADS software.

The CAS/ADS can upgrade the database schema several versions are supported* - it is what happens during the upgrade process, the CAS is temporarily started to upgrade the schema by the installer process.

* check the upgrade path documentation, it will give an indication what versions can be upgraded directly, and which versions need multiple steps.

https://community.dynatrace.com/community/display/...

2 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Hello Chris,

Thanks for replying, May I know what is the name for configuration table which I need to query to find out the version? Support gave me below query but seems table is not found.

Select * from DBHistory

Also is there a way to find below info from restored CAS server DBs:-

-find out software services running inside the DCRUM

-to check all reports configured with name "IRAS" or my be query to check all reports will also do.

Basically I am trying to identify the content of the DB before I install the APP again and link it to the DB.

0 Likes 0 · ·

Sorry for the delay in replying again, I missed the response.

If you're querying the database from SQL directly, you need to be in the 'delta' schema, most easily accomplished by adding delta. to the front of any table names.

e.g. to get a list of reports from the database...
`SELECT * FROM delta.LSEntry WHERE name LIKE '%IRAS%'`

To get a list of 'seen' software services (traffic recorded as opposed to just configured, you'd need to check the RUMC database for that), try.

`SELECT * FROM delta.rtmApplications`

The current version of the database will be the last line of this query....

`SELECT * FROM delta.DBHistory`

0 Likes 0 · ·