Server Management - Systems Insight Manager
1834661 Members
3580 Online
110069 Solutions
New Discussion

Re: Upgrade SIM4.1SP1 -> SIM 4.2 are there DB-changes ??

 
SOLVED
Go to solution
Guido Koetter
Frequent Advisor

Upgrade SIM4.1SP1 -> SIM 4.2 are there DB-changes ??

Hello,

we are using several tools for monitoring our network. These tools get their data via sql-statements against the Insight_V41.... -DB.

SIM 4.2 installs a new instance called Insight_V42.... What about the tables and views inside this new DB??
Is it enough to switch the odbc-connection? Must I recreate the sql-statements??

Best regards

Guido
3 REPLIES 3
Darrin Rawls
HPE Pro
Solution

Re: Upgrade SIM4.1SP1 -> SIM 4.2 are there DB-changes ??

You should just be able to change the ODBC for your app to point to the 'new' db and it should work fine.


I work at HPE
HPE Support Center offers support for your HPE services and products when and how you need it. Get started with HPE Support Center today.
[Any personal opinions expressed are mine, and not official statements on behalf of Hewlett Packard Enterprise]
Accept or Kudo
Rob Buxton
Honored Contributor

Re: Upgrade SIM4.1SP1 -> SIM 4.2 are there DB-changes ??

My Upgrade from 4.1 to 4.2 has retained the original database.
It still has the original 4.0 name.

I don't know what changed but a couple of the queries I run are producing different results.
I think this is down to changes in data at this point, e.g. I had a query that used the "Microsoft Windows" in the OSVersion, Windows 2003 Servers now have "Microsoft(R) Windows(R)" for some odd reason.
Guido Koetter
Frequent Advisor

Re: Upgrade SIM4.1SP1 -> SIM 4.2 are there DB-changes ??

Thanks !

Guido