Passing parameters to migration scripts

EricLamontagne · July 30, 2020 4:24PM

Hi,

My understanding is that SCA uses sqlcmd to execute the migrations scripts.

In these migrations scripts, there is a parameter (variable) $DatabaseName.

Is there a way for me to have my own set of parameters/variables that I would pass from my powershell script to the migration script?

Regards,

Eric Lamontagne

Ivo_Miller · August 4, 2020 10:51AM

Hi,

For deployment, if you are using the PowerShell cmdlets directly, see example 6 here: https://documentation.red-gate.com/sca/reference/powershell-cmdlets/new-databasereleaseartifact
If you are using the SQL Change Automation release plugin for Azure DevOps or the SQL Change Automation step templates for Octopus deploy, any environment variables you define will automatically be passed in as SQLCmd variables.

All the best,

Ivo Miller

Sergio R · August 3, 2020 2:51PM

Hi Eric,

Yes, please see https://documentation.red-gate.com/sca/developing-databases/concepts/advanced-concepts/variables for more information regarding this.

Kind Regards,

EricLamontagne · August 3, 2020 2:55PM

Hello Sergio,

This is what I was looking for, thank you very much.

On the other hand, I can't find how to SET the value of a variable at deployment time... can you tell me how it can be done?

Thanks,

Eric Lamontagne

EricLamontagne · August 4, 2020 6:54PM

Great, thank you!

Passing parameters to migration scripts

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk