Oncology App - Deployment
One of the learnings from this application development was the use of deployment tools and source control.
Everything was under source control including the database, which meant that everything had to be scripted.
All of these scripts (application and database) were deployed using Octopus.
What this meant from a database perspective was that there were two Power hell scripts that did everything.
The first installed and configured SQL Server (Enterprise or Developer edition, developer was the default but Enterprise could be passed as a parameter instead).
The second created the application database (default was the usual name, but a parameter could be passed to create a database of a different name if required).
By using Powershell and some looping additional scripts could be easily added and the database recreated within a few hours, complete with sample/test data.