Join Brian Randell for an in-depth discussion in this video Dealing with drift, part of DevOps for the Database with TFS 2018.
- [Instructor] Now in a perfect world,…if you start using SSDT, your project,…this off-line copy, becomes a source of the truth…when it comes to the definition of your database structure.…The reality is that it's possible that your databases…that are deployed inside SQL server…can have changes made to them that you need…to incorporate into your project.…This is known as drift,…and we want to be able to resolve this.…There's two levels of drift.…One is resolving drift within instances…that you work with as a developer.…
Then there's drift at larger scale in your organization…as well as within your development team.…The mechanism I'm going to show you now…is using a tool called Schema Compare,…which is built into SSDT.…This is particularly useful for dealing with things…at a smaller scale, your workstation, or even a small team.…In the last chapter of this course,…I'll show you how to deal with drift at scale.…Let's switch over and take a look at how we can get…our database that has changed in sync with our project.…
- 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.