PostgreSQL

The last thing that remains is our production database. We can quite easily set up our new database as we still have all the scripts we need to set it up. Do not worry about all the pgTap scripts. We are not going to test this database; we already did that on our development database after all. Simply run the CREATE DATABASE script in pgAdmin, but be sure to rename the database to something such as "webshop-prod" (quotes necessary):

CREATE DATABASE "webshop-prod"   [...]

Now open the query tool on the new database and execute the rest of the scripts.

To configure our database connection string in .NET Core, we will need to do a little refactoring (and do things the correct way). We can add the connection strings to the appsettings.json ...

Get Continuous Integration, Delivery, and Deployment now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.