Upgrade and move SQL Response 1.3 to SQL Monitor 2.x
BrandonGalderisi
Posts: 22
We have just stood up a dedicated monitoring box that we want to move SQL Monitor on. We are currently using SQL Response 1.3 on a different box. I want to upgrade and retain history contained on our old monitoring box. I have looked for installation documentation for this scenario but did not find any.
Please advise.
Please advise.
Comments
Unfortunately, Sql Response alert history cannot be imported into Sql Monitor.
However, you can keep the 1.3 installation running in parallel to consult its history until it's no longer valuable. Naturally, you'd want to de-register the servers so it's not performing any monitoring.
Being able to import history from Sql Response would allow you to have everything in one place, but sadly the formats are wildly different as is the scope of what's collected and stored.
Regards,
Development
Red-Gate Software
If so, how do I move the alert history form one collection agent to another?
There's a knowledge base article which explains how to move the data files.
www.red-gate.com/supportcenter/Content?c=knowledgebase\SQL_Response\KB200811000321.htm&p=SQL Response
(please copy the link as the forum's parser doesn't like it)
Unfortunately, de-registering the servers prevents you from viewing the alerts. As a work around, you could run the 1.3 monitoring service as local service, which won't have the permissions needed to monitor.
Development
Red-Gate Software