Join Brian Randell for an in-depth discussion in this video Static data, part of DevOps for the Database with TFS 2018.
- [Narrator] Static data, or data that doesn't change often…that is included as part of the…base database deployment, is another concern.…If you think about applications,…they often use lookup tables.…Things like postal codes, if you have a product database,…it might have standard SKU numbers, pricing.…Whatever supports the application that doesn't change all…the time, and is often necessary in order for the app to…function on top of the database from the beginning,…could be something that's included…as part of your SSDT project.…
You can simply include that as part of your…post-deployment scripts, and when your DACPAC…is deployed, it will run the inserts after the database…is created and all the objects have been set up.…Another option is to restore an empty database,…as far as customer data, that has any of the stack data…already in it, and then use SSDT or…the publish task in the DACPAC to transform…the database into the current version.…And finally, we have custom scripts and tooling.…Naturally this could run the gamut from simple to exotic.…
- 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.