Errors can happen when modifying database entities. Bad choices in the table designer could jeopardize data integrity or ruin the database schema. This tutorial looks at the messages and error screens provided the SQL Server Data Tools to prevent bad things from happening to your data.
- [Voiceover] When you change the data structure…of a table and attempt to update the database,…Visual Studio looks at your pending changes…and attempts to verify whether the changes will work…against the current database.…If not, it will surface a message…so that you can correct the error.…On a simple change,…like just adding a new field to a table,…the chances of having an error are low.…But on a more complex change,…for example, let's say I change the…primary key of a table,…that would effect every foreign key…that I have in all my other tables.…
So in that scenario I should get a message…that tells me about that,…and then I should be able to go through…and change all the tables to correct…that error before updating.…That's what I want to show in this video,…is how Visual Studio surfaces…those errors and those messages.…I'll look at the data in this Tours table first.…I recently added the Meals Included column.…See what's inside the data for each of these rows,…the value Null.…So the values that are allowed for this…
- Exploring integration with Azure data sources and other Microsoft databases
- Working with SQL Server Express LocalDB
- Connecting to databases with Server Explorer
- Working with database tables
- Manipulating tables with the SQL Server Object Explorer
- Creating queries and custom views
- Creating stored procedures
- Comparing databases
- Building a data project in Visual Studio
- Refactoring a database object
- Deploying the database
- Connecting to Azure databases
- Deploying data projects to Azure
- Integrating Visual Studio with Entity Framework
Skill Level Beginner
Q: This course was updated on 08/23/2017. What changed?
A: The following topics were updated: installing the SSDT features and why LocalDB is essential for developers.
1. Database and Data Integration
The Azure data sources2m 35s
2. SQL Server Express LocalDB
3. Server Explorer
4. SQL Server Object Explorer
5. Queries, Views, and Stored Procedures
6. Compare databases
7. SQL Server Data Project
8. Azure Data
Get an Azure account1m 10s
9. Entity Framework
- 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.