Join Brian Randell for an in-depth discussion in this video Testing as part of release, part of DevOps for the Database with TFS 2018.
- [Instructor] Now, it's one thing…to being doing testing locally on your machine,…but you're also going to want to do tests…in your various environments.…You'll want to do this in an automated fashion.…Now, typically, through the model of continuous integration,…you're going to be encouraged to run unit tests…as part of a Team Build.…It's very natural.…Unfortunately, it's a bit unnatural…due to the fact that you need this database…and it has to be in a consistent state…and have the appropriate data inside it.…I prefer to do it after release,…whenever I deploy into an environment.…
So what you're going to do is do a build,…that's going to create your DACPAC…and your unit test library, if you're using the SSDT.…You're then going to do a release,…and once a release is done in an environment…like a shared data environment,…you'll then run the tests.…You'll then look at the test results and validate,…and if they're good, you can move onto the next environment.…To do this, you're going to use the Visual Studio Test task…
- Team Foundation Server (TFS) 2018
- SQL Server Data Tools (SSDT)
- Configuring version control of a SQL database
- Installing and importing a database
- Setting up users, team build, agents, and pipelines
- Handling changes, branching, and merging
- Making local deployments
- Building a database for SQL Server
- Continuous integration
- Continuous deployment
- Working with multiple groups and environments
- Testing databases using frameworks
- Working with static data and data motion
- Versioning a database
Skill Level Intermediate
1. Tooling Overview
2. Version Control Your Database
3. Build Your Database
4. Release Your Database
5. Test Your Database
6. Real-World Issues
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.