Database Continuous Delivery
by Nicholas Tuck
1. Codes and Demo
1.1. sql server databases
1.2. sql server management
1.2.1. sql source control
1.3. can commit the change
1.3.1. see the dif, easy to read
1.4. team city auto builds it into a nuget package
1.4.1. nuget package can be tested against a brand new database
1.4.1.1. then will generate the deployment package
1.5. can generate test data based off of rules
1.5.1. sql data generator by red gate
2. Verrry $$$ Tools
3. Similar Talk
3.1. http://workingwithdevs.com/delivering-databases-migrations-vs-state/
4. Other Tool
4.1. https://klonio.com/
5. Speaker
5.1. Jeff French
5.2. Moonswitch Softaware
5.3. @jeff_french
6. Migrations
6.1. problem
6.1.1. they describe how a database needs to change
7. Desired State
7.1. describes the state I want the database to be in at this point
7.2. tool should do whatever it takes, should handle that transition for me
7.3. helps
7.3.1. change the database to the end goal, the actual state
7.3.2. validates the end state
7.3.2.1. migration changes you have to go manually validate afterward anyways... automate this