Function to generate Multi Script project configuration

[alevyinroc]

Request for a new function which can generate a Multi Script project configuration file. At a minimum, the information build out the connection & database list. Ideas:

• Accept an optional PSCredential object to use for embedding SQL Authentication credentials in the configuration. Multi Script encrypts/encodes the passwords (good!) and the method for doing that is unknown to people outside Red Gate.
• Accept a list of databases for the target server to add into the configuration, as an input object (collection) or via the pipeline.
• Create the configuration file in an alternate location (so your default/normal one isn't disturbed)
• Launch Multi Script with the newly-created configuration file

One possible usage (assuming one has the dbatools module):

$cred = Get-Credential -username "MyUser" -Message "SQL Credentials"
Get-DbaDatabase -SqlInstance "MyServer" -Credential $cred | Where-Object {$PSItem.Name -like "a*"} | New-MultiScriptConfig -ServerName "MyServer" -Launch

Quick first thoughts, definitely open to discussion. I have delved too far into command-line usage of Multi Script but having Powershell control of more of Multi Script could be useful.

[sqlwhale]

The first version of the multiscript cmdlets have been added to the module. They are Get-RedgateMultiScriptConfigurationFileInfo and Set-RedgateMultiScriptConfigurationFileInfo. The set command needs more documentation but I've tested it a good bit. You should now be able to generate distribution lists that you can import in multiscript. It also has the ability to change your Application.dat file but I would just generate a new file and pull it in. Kick the tires and let me know what you think. I need to start working on unit tests for the module and I'll build in some examples.

[alevyinroc]

Thanks, I'll check it out soon!

[alevyinroc]

I didn't forget about this!

I must be doing something wrong. I'm running the following:

get-dbadatabase -ServerInstance MYSERVER|?{$_.name -match '^\d+$'}|select-object sqlinstance,name | Set-RedgateMultiScriptConfigurationFileInfo -DistributionList NewTest -As DistributionList -IntegratedSecurity

It creates a new Application.dat but it appears to be invalid, as I don't see the distribution list in MultiScript and MultiScript rewrites the file almost completely empty as soon as it opens.

If I open the Application.dat in Notepad++, the XML appears to be OK, but I haven't reviewed it in depth yet.

[sqlwhale]

Hmm.. I know from our conversations you said that you wanted this to work to store credentials. Did you just try to build a generic file? I really need to see the file you're generating to be able to tell what's wrong with it. Is there anyway you can obfuscate it and share it with me? You can send it to my email address if you don't feel comfortable posting it here.