New training: Streamlining alerts in SQL Monitor. Watch now.

Export SQL Server List?

Hello All,
I need to know if there's a way I can export my list of sql servers from SQL Monitor 9 so I can import it into SQL Monitor 11; any suggestions? TIA
Tagged:

Answers

  • Jon_KirkwoodJon_Kirkwood Brisbane, Australia Posts: 15 Bronze 1
    Hi, 

    Thanks for reaching out through the Redgate forums.

    If you are upgrading from SQL Monitor 9 to 11 on the same machine it should retain the same repository database so your configuration & monitored servers persist between versions
    Here are a couple of handy links for upgrading to SQL Monitor 11 from older versions
    Upgrading SQL Monitor
    Locating the SQL Monitor Database
    Always recommended to take backups of files before upgrades so you can roll back if it doesn't go as planned. 


    It may be possible to create some PowerShell scripts that will extract lists of servers in Monitor and then be used to create another import script to re-create them in a new instance.
    Using API / Powershell Module

    Example scripts can be found in your SQL Monitor dashboard by navigating to Configuration > API > View example Powershell scripts
    The 'List all monitored entities' & 'Add server' scripts may provide a good starting point to modify for your specific requirements



    Jon Kirkwood | Technical Support Engineer | Redgate Software
  • RiffMongerRiffMonger Posts: 2 New member
    edited October 13, 2021 10:19PM
    Anyone else? I'm hoping there's something that doesn't require a lot of circus acts (jumping through hoops) to get this list, but it doesn't seem to be available.
Sign In or Register to comment.