Monthly archive

Generate Red Gate MultiScript .dat File

ben himself's picture

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.