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.


  • 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.