Make Update-Database able to update any database

[JorgenLindell]

I am working in an environment where I have multiple versions of the database in parallell, i.e Development, Migration and Production.

I have a problem when I have made changes via migrations in my Development database and is going to deploy to my Mig and Prod environments, as there doesn't seem to be any simple way through "update-database" to point it to any other database than my development one.

How is this supposed to be done?

I would have liked "Update-database" to take a connection string parameter and be able to apply the missing migrations to any database I point it to.

Currently I am using the schema diff functionality in VS to create a diff script between dev and the target database, but this is a manual step, and as such prone to errors.

[popcatalin81]

@JorgenLindell In the case, you're describing the migrations are usually applied at runtime during application bootstrap.

https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/#apply-migrations-at-runtime

[ajcvickers]

Duplicate of #10750