-
Notifications
You must be signed in to change notification settings - Fork 23
Open
Labels
enhancementThe issue is an enhancement request.The issue is an enhancement request.help wantedThe issue is up for grabs for anyone in the community.The issue is up for grabs for anyone in the community.
Description
How can I pass a variable in the DACPAC post-deployment script with xDatabase?
For example in the following post-deployment script:
EXEC ('ALTER DATABASE [$(DatabaseName)] MODIFY FILE (NAME = [$(DatabaseName)], SIZE = 100MB, MAXSIZE = UNLIMITED, FILEGROWTH = 20%)');
I can pass $(DatabaseName) by referencing it in
{
Ensure = 'Present'
SqlServer = 'localhost'
SqlServerVersion = '2014'
DatabaseName = $DatabaseName
Credentials = $Credential
DacPacPath = 'C:\DatabaseTest.dacpac'
DacPacApplicationName = $DatabaseName
DacPacApplicationVersion = '1.0'
}
But how can I pass $(databaseSizeSQLCMD) in the following script?
EXEC ('ALTER DATABASE [$(DatabaseName)] MODIFY FILE (NAME = [$(DatabaseName)], SIZE = $(databaseSizeSQLCMD), MAXSIZE = UNLIMITED, FILEGROWTH = 20%)');
Metadata
Metadata
Assignees
Labels
enhancementThe issue is an enhancement request.The issue is an enhancement request.help wantedThe issue is up for grabs for anyone in the community.The issue is up for grabs for anyone in the community.