Home / Companies / Octopus Deploy / Blog / Post Details
Content Deep Dive

Deploying to SQL Server with Entity Framework Core - Will it Deploy? Episode 3

Blog post from Octopus Deploy

Post Details
Company
Date Published
Author
Rob Pearson
Word Count
317
Language
English
Hacker News Points
-
Summary

In a "Will it Deploy?" episode, Rob Pearson demonstrates automating the deployment of a Microsoft SQL Server database using Entity Framework Core migrations to an AWS virtual machine with Octopus Deploy. The featured application, Random Quotes, is a simple ASP.NET Core 2.0 web app backed by a Microsoft SQL Server 2017 database, developed initially by marketing manager Andrew. The deployment targets an AWS EC2 virtual machine running Microsoft Windows Server 2016, utilizing Octopus Deploy steps to manage the process, including copying database scripts, executing migration scripts, and deploying the web application to IIS. The episode's GitHub repository provides all necessary resources and links, inviting viewers to suggest future topics and subscribe for more content.