Each SQL Server Data project has a dedicated debug database that is automatically created by the SQL Server Data Tools. This database is isolated in a special SQL Server named instance. This tutorial explores where this database is located, when the database is created and how to use the debug menu to deploy your SQL files to the debug database.
- [Voiceover] This database project…has a number of sequel files…that represents the items…I want to put in the database at some point.…Currently, they're all just SQL files.…I'll need to run those SQL files at some point,…and put them inside a database.…But what database do I put those files in?…Do I put them in the database…that I used to originally import the data?…Do I put 'em in a test database?…Well the good news is the engineers at Microsoft…have thought through this problem,…and what they do is they'll automatically put your items…in a special debug database,…or sometimes called the Sandbox database.…
Let me show you what I mean.…The original database…that I used to import this information is over here…in this MSSQLLocalDB instance, sys database here.…The Sandbox version is inside the separate named instance…called ProjectsV13.…I open this up and look in the database node.…You'll see the name of this is Northwind-Import_1.…It should match the name of my project.…In my case, it has an extra underscore one at the end,…
- 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.