Managing database revisions in .Net

Tech talk covering alternatives to manage database revisions in .Net

Transcript

1. Managing database revisions in .Net
2. The problem
3. Database evolution Continuous Integration We want
4. SQL Data Tools Migrations x Solutions in .Net
5. SQL Data Tools
6. SQL Data Tools Visual studio template project
7. SQL Data Tools Diff based Visual studio template project
8. SQL Data Tools Diff based Compilated scripts Visual studio template project
9. SQL Data Tools Diff based Visual studio template project Linkedservers issue (-1) Compilated scripts
10. SQL Data Tools Diff based Visual studio template project Current schema can be imported (+1) Linkedservers issue (-1) Compilated scripts
11. SQL Data Tools Diff based Compilated scripts Visual studio template project Current schema can be imported (+1) Linkedservers issue (-1) Continuous integration issue (-1)
12. Migrations Migrations
13. Migrations Version based
14. Migrations Version based Open source project (+1)
15. Migrations Flexible (+1) Version based Open source project (+1)
16. Migrations Non-compilated scripts Flexible (+1) Version based Open source project (+1)
17. Migrations Non-compilated scripts Flexible (+1) Version based Database engine freedom (+99) Open source project (+1)
18. Migrations Open source project (+1) Non-compilated scripts Flexible (+1) Version based Database engine freedom (+99)
19. fluentmigrator vs sharpmigrations
20. fluentmigrator sharpmigrations vs 914 stars 362 forks 47 open issues PR 12 open / 309 closed 1531 commits last commit Jun 20, 2015 documentation 27 wiki pg 107 Contributors Sean Chambers - lostechies.com 24 stars 8 forks 7 open issues PR 0 open / 4 closed 112 commits last commit Jun 15, 2015 documentation 1 wiki pg 3 Contributors Andre Carlucci - Microsoft MVP
21. fluentmigrator > sharpmigrations
22. History, Runners, Tools and Testing fluentmigrator
23. fluentmigrator demo