Join Brian Randell for an in-depth discussion in this video Local deployments, part of DevOps for the Database with TFS 2018.
- [Instructor] At this point, we've worked with…our database project very quickly offline.…But one of the things we noticed is that…we were making changes to some text files on our hard drive.…It wasn't changing SQL Server.…What we want to be able to do then…is take our changes and get 'em into SQL Server…and see the results of our work.…To do that, we're going to do an F5.…F5 being the default shortcut key…of Visual Studio to build and run.…
With SSDT, that effectively means doing a deployment…or publishing our project into an SQL Server instance.…This allows up to deploy and validate our work…and possibly do tests.…I typically recommend that people use…a local SQL Server Developer Edition copy…for their private F5 deployments.…And then later, we're going to do deployments again…in a shared dev environment,…but we're going to do it with Team Build.…So let's take a look at how we can do F5…deployments to a local copy of SQL Server.…
- 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.