Moving SQL Monitor to new OS and upgrades

WINZICTWINZICT Posts: 3 New member
edited April 24, 2019 12:52PM in Redgate Monitor
HI, 

We want to move the SQL monitor to a new box with new OS, the SQL database will remain on the existing external SQL server.  
We also want to upgrade from 8.x to 9.   What would be the best procedure to cut down on reconfiguration etc?
Tagged:
· Share on Twitter

Best Answers

  • Russell DRussell D Posts: 1,324 Diamond 5
    Answer ✓
    If you're not even moving the Monitor repository there isn't much to do. Install Monitor on the new server and point it to the existing database which will then be upgraded as part of the install. Couldn't be simpler.
    Have you visited our Help Centre?
    · Share on Twitter
  • WINZICTWINZICT Posts: 3 New member
    edited April 29, 2019 9:09AM Answer ✓
    And if we need to move the Database?  
    Since I found that 9 no longer supports SQL 2008 r2. 
    · Share on Twitter
  • Russell DRussell D Posts: 1,324 Diamond 5
    edited April 29, 2019 9:39AM Answer ✓
    The principle is the same, just migrate the database to a supported version of SQL first, then move the database to the new server (if changing server rather than just upgrading SQL), then point the installer at the migrated database.
    Have you visited our Help Centre?
    · Share on Twitter

Answers

Sign In or Register to comment.