Join Brian Randell for an in-depth discussion in this video Testing locally with SSDT: Demo, part of DevOps for the Database with TFS 2018.
- In order to run unit tests,…we need to go into Visual Studio,…and we're going to expand,…our solution inside the solution explorer in Visual Studio,…and you'll note that we have these store procedures.…If I right-click on one,…we get a menu option for create unit tests.…This will open the create unit test dialogue,…and provide you with a list of all the programmable objects,…that, the unit test project understands.…In this case, I've selected CustOrderHist,…but I could select additional items if I want.…
But I'm just going to start with…this single store procedure.…Then you'll notice down here in these to generate a project.…This is going to be a Visual Studio, test project,…and this project is backed by either C# or vb.net.…And you can control that via the project drop-down.…I'll use C#, but, vb.net works just fine if you prefer that.…I need to give it a name,…so we'll call this Northwind,…Db,….Db,…Unit…Tests.…
That's the name of the project.…Finally, we need to name the…class that backs up our procedures,…and we'll call this,…
- 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.