How do I update my prod database with dotnet ef database cli command?

Question

How do I get EF to build all the tables for the prod db?

So far I've been building and pushing all my .Net Core database migrations to the dev db

ex.

>dotnet ef migrations add InitialModsN -c Auto2Context

>dotnet ef database update -c Auto2Context

In my Appsettings.Development.json file I have my con string pointing to dev db 'source=DEV'

"ConnectionStrings": {
"DefaultConnection": "Data Source=Auto2.db",
"Auto2": "data source=DEV; initial catalog=Auto2; user id=auto2; password=12345;" }

And my Appsettings.json I have the prod db con string pointing to the prod db 'source=LIVE'

"ConnectionStrings": {
"DefaultConnection": "Data Source=Auto2.db",
"Auto2": "data source=LIVE; initial catalog=Auto2; user id=auto2; password=12345;" }

So far everything is being built and migrated to dev, how do I change this to build all the changes up to date in the prod db?

Do I have to re create an initial migration file and then update? If yes, how do I point it to the prod db? I tried a couple of different commands with no luck. Here is what I tried.

>dotnet ef database update -c Auto2Context --connection "data source=LIVE; initial catalog=Auto2; user id=auto2; password=12345"

-received 'Unrecognized option '--connection''

>dotnet ef database update -c Auto2Context --configuration Release

no tables created in the prod db

Mohsen Esmailpour · Accepted Answer · 2020-05-30 19:28:29Z

1

Set ASPNETCORE_ENVIRONMENT environment variable before executing the command:

$env:ASPNETCORE_ENVIRONMENT='Production'

edited May 30, 2020 at 19:28

answered May 28, 2020 at 22:32

Mohsen Esmailpour

11.6k3 gold badges49 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

chuckd Over a year ago

Unrecognized option '--environment' and Unrecognized option '-e'

chuckd Over a year ago

also I see this: ASPNETCORE_ENVIRONMENT='Production' in a couple of different files. Launchsettings.json and launch.json.

Mohsen Esmailpour Over a year ago

As far as I know $env:ASPNETCORE_ENVIRONMENT='Production'should works see this

chuckd Over a year ago

this doesn't seem correct as I would have to go into the file where this line exists and manually change it every time I go in-between dev and prod. That doesn't correct..

chuckd · Accepted Answer · 2020-05-31 04:27:31Z

0

Here is what I used and it seems to work.

dotnet publish --configuration Release /p:EnvironmentName=Production

but this only builds the application. I had to run this command below to create a sql script to update the prod db.

dotnet ef migrations script -i -o "buildscript.sql" -c Auto2Context

Is this the best/correct way to push db changes to prod?

edited May 31, 2020 at 4:27

answered May 29, 2020 at 1:32

chuckd

14.8k34 gold badges182 silver badges407 bronze badges

Collectives™ on Stack Overflow

How do I update my prod database with dotnet ef database cli command?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related