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.

NOTICE:

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

Tags: 

Categories: