access recorded data of previous server
We have a single server license for SQL Monitor and monitored our old database in the two weeks before migrating everything over to a new SQL Server. The machine and SQL Server instance have new names. I am not interested in monitoring the old server since it is being decommissioned.
However, I want to compare what I see now on the new server with the last two weeks of the old server, but I cannot access the old server's data in the Analyse view any more. Although, I can still see it in Overview if I set the date back.
Is there a way that I can bring the old data over to the new sql server? Perhaps updating the Redgate monitoring database to move all historic data over to the new server? Is there some recommended action I can take to access the old data in the analyse view?