re: DAC Powershell Samples

Carl Prothman — Wed, 13 Mar 2013 18:44:20 GMT

To get past the "is not digitally signed. The script will not execute on the system", see:

dmitrysotnikov.wordpress.com/.../unblocking-powergui-add-ons-and-powershell-modules

re: DAC Powershell Samples

Carl Prothman — Tue, 12 Mar 2013 22:33:47 GMT

Import-Module : File DACModule.psm1 cannot be loaded.

The file DACModule.psm1 is not digitally signed. The script will not execute on the system.

For more information, see about_Execution_Policies at

go.microsoft.com/fwlink.

re: DAC Powershell Samples

Tye Akoiye — Mon, 09 Apr 2012 20:57:27 GMT

Are all the outlined steps the actual order you need to follow in order to deploy DAC via PS? When I attempt to "Build-Dac" and pipe it to Save-DAC", I receive the following error:

$serverConnection = Get-ServerConnection –serverName “MySQLServerInstance”

$path = "C:\Temp\My PowerShell\DAC\"

$buildFile1 = "C:\Temp\My PowerShell\DAC\"

$buildFile2 = "C:\Temp\My PowerShell\DAC\"

$dacType = Build-Dac –dacTypeName "DacCompile" –files @($buildFile1, $buildFile2)

Save-DacType –dacType $dacType –dacpackPath $path

#$dacType = Extract-DAC –serverConnection $serverConnection –databaseName "dba_admin" –dacTypeName "dba_admin" –dacTypeVersion "1.0.0.0" –dacPackPath $path

Save-DacType : Cannot process argument transformation on parameter 'dacType'. Cannot convert the "System.Object[]" value of type "System.Object[]" to type "Microsoft.SqlServer.Management.Dac.DacType".

At line:9 char:22

+ Save-DacType –dacType <<<< $dacType –dacpackPath $path

+ CategoryInfo : InvalidData: (:) [Save-DacType], ParameterBindin...mationException

+ FullyQualifiedErrorId : ParameterArgumentTransformationError,Save-DacType