Generate Red Gate MultiScript .dat File

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.

Tags: 

Post date
SQL Server - Timestamp Column Monday, May 2, 2016 - 22:42
PowerShell - Get All SQL Instances On Server Wednesday, April 27, 2016 - 21:48
PowerShell - Get "Logon As" Information From Remote (or local) Server Wednesday, April 20, 2016 - 00:45
T-SQL - Get Currently Running Jobs With Duration Thursday, April 14, 2016 - 23:38
Restore All Databases With Most Recent Backup Thursday, April 14, 2016 - 17:17
PowerShell - List All Directories With Users Who Can Access Friday, April 8, 2016 - 22:50
SQL Server - Database Stuck In Single User Mode Tuesday, March 29, 2016 - 04:23
SQL Server - Cluster Queries Thursday, March 24, 2016 - 03:24
Favorite Computer Environment Tools Thursday, March 24, 2016 - 00:36
SQL Server - Getting All SQL Services Running On System Wednesday, March 23, 2016 - 23:11