Access the database name inside Up in DbMigration

I have the following code in a code-first migration: ``` public partial class RunSQLInit : DbMigration { public override void Up() { this.Sql(SqlFiles.Create_Job_ClearExpiredData); } [...] } ``` where `SqlFiles.Create_Job_ClearExpiredData` is a resx-file returning an SQL-file as a string. The SQL creates and schedules a Server Agent job in SQL Server. Now, the SQL have two "variables" I need the ability to change before running the migration on a database: the name of the database the job should run on, and the name for the actual job. That would be fine if I had one environment only, but I deploy this code-first project to a number of environments, who differ in database names and also in what I should call the Job. I see three possibilities: - Get hold of the connection string currently being used inside the Up()-method, and use that to parse out the database name and do a replace for it to the SQL-string before running it. But how would I go about getting the "connection string currently being used"? - Somehow pass a variable to the migrations when running `Update-Database` in the Package Manager Console, which could be accessible inside the migrations. How would I go about that? - Use another solution for creating the Job. We rely heavily on the ease of deploying from the code-first models to all environments, so it should be easily automated somehow without additional labour when updating databases, and producing deployment scripts (with `Update-Database -script`) A small cut out from the SQL-script in question is this: ``` EXEC msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Run SP', @step_id=1, @subsystem=N'TSQL', @command=N'exec sp_ClearExpiredData;', @database_name=@databaseName, --This is where I need the varying database name! @flags=0 ```