Deploying to SQL Server with a DACPAC - Will it Deploy? Episode 4

In this episode of "Will it Deploy?", Rob Pearson demonstrates the process of automating the deployment of a Microsoft SQL Server database using a Data-tier Application Package (DACPAC) to an Amazon Web Services (AWS) virtual machine via Octopus Deploy. The episode features the deployment of a simple ASP.NET Core 2.0 web app called Random Quotes, developed by marketing manager Andrew, to illustrate database changes and updates. The deployment is accomplished by using specific Octopus Deploy steps, including copying database scripts, deploying DACPAC to the SQL Server database, and deploying the ASP.NET Core application to IIS on a Microsoft Windows Server 2016 running on an AWS EC2 virtual machine. The episode's GitHub repository provides all necessary resources, and viewers are encouraged to suggest new technologies for future episodes and to subscribe for regular updates.