Join Brian Randell for an in-depth discussion in this video Version control your SQL DB with Git: Demo set up, part of DevOps for the Database with TFS 2018.
- [Brian] We're now ready…to take our database,…in this case the Northwind sample database,…and put it under version control…with an SSDT project.…What we're going to do is going to go to our task board,…and I'm going to mark this task as being in progress,…because this is what I'm going to do.…In this video, we're going to go through…and add the database to Git version control…in Team Foundation Server.…In a second video, I'll do the same process,…but instead I'll use Team Foundation version control.…
As I do this demo, I'm also going to show you what it's like…to make changes to the project file…and share the differences with a team member.…So let's go over here to Visual Studio 2017.…When you work with Team Foundation Server…for Visual Studio, you use what's called the Team Explorer.…You can find it by going to the View menu…and selecting Team Explorer.…The very first time you come in you won't have a connection,…so you can come over here and select the Manage Connections…connectoid and then you can come over…
Author
Released
3/8/2018- 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
Duration
Views
Related Courses
-
DevOps with Visual Studio Team Services (2017)
with Paul Hacker1h 12m Intermediate -
Learning Visual Studio Team Services
with Jose Miguel Rady Allende1h 17m Intermediate -
Azure Search for Developers
with Chander Dhall2h 8m Beginner
-
Introduction
-
Welcome57s
-
What you should know2m 38s
-
-
1. Tooling Overview
-
DevOps overview2m 31s
-
DevOps for databases2m 25s
-
Supporting tools2m 43s
-
End-to-end demo3m 38s
-
-
2. Version Control Your Database
-
Why version control?1m 45s
-
Team project setup: Demo5m 6s
-
Backlog: Demo7m 20s
-
Sample database installation2m 28s
-
Branching and merging1m 2s
-
Local deployments1m 8s
-
Dealing with drift: Demo4m 40s
-
-
3. Build Your Database
-
Team build1m 39s
-
Agents1m 18s
-
Pipelines1m
-
Agents and pipelines: Demo3m 24s
-
Continuous integration1m 46s
-
Continuous integration: Demo5m 28s
-
-
4. Release Your Database
-
Why release management?1m 47s
-
Agents and pipelines?1m 27s
-
Deployment groups1m 40s
-
Deployment groups: Demo3m 14s
-
Continuous deployment2m 20s
-
Continuous deployment: Demo6m 48s
-
Multiple environments: Demo6m 48s
-
-
5. Test Your Database
-
Why test?2m 24s
-
Database testing frameworks2m 36s
-
Testing as part of release1m 13s
-
Testing and release: Demo11m 11s
-
-
6. Real-World Issues
-
Data motion1m 13s
-
Static data1m 33s
-
Database drift at scale1m 32s
-
Testing at scale42s
-
Versioning the database1m 18s
-
Apps and databases1m 42s
-
Add website to project: Demo6m 18s
-
Conclusion
-
Next steps59s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Version control your SQL DB with Git: Demo set up