This is a PowerShell script that puts out the XML required to update your Red Gate MultiScript servers. Manually entering the SQL instances from within the application can be a daunting task if you have a large number to do. This script will have you up and running in seconds.
You must first have a comma-separated list of your instances to load into the array. Once you have that, set $instances equal to your list. Notice that the .dat file will launch in Notepad to make it easy to paste in the results. Then, save the file and you're done.
- Be sure MultiScript is closed before beginning or else it may not save your file
- The output does not merge with your existing servers. When saved, you will be overwriting your existing .dat file.