Skip to content

Variable Substitution

Curiosity.Migrations supports basic variable substitution.

How to use

To use variable substitution you should register variables when configuring migrator:

var variableValue = "my_variable";
var builder = new MigratorBuilder();
builder.UseVariable("%VARIABLIE%", variableValue);

Script migrations

Then in your database script use this variables:

-- %VARIABLIE% %AnotherVariable%

After running migrator script will be transformed:

-- my_variable %AnotherVariable%
SELECT * FROM dbo.my_variable

Code migrations

Default variables

All providers by default provide next variables:

  • %USER% - name of user from connection string
  • %DBNAME% - database name