Visual Studio contains two IDE windows that work with databases; Server Explorer and SQL Server Object Explorer. Either tool can be used to connect to databases and explore and modify the data entities within the database. This video explores the differences between the two IDE windows and provide some guidance for choosing the best one for a specific task.
- [Voiceover] Visual Studio contains two IDE windows…for working with databases, a Server Explorer…and SQL Server Object Explorer.…Either tool can be used to connect to databases…and explore and modify the data entities…within the database.…This video explores the differences…between the two IDE windows, and provides…some guidance for choosing the best one…for a specific task.…This is the default window layout in Visual Studio.…You can see that on the left side of the screen,…there's a Server Explorer over here.…I'll click on it and click on the Auto Hide button…to pin it to the side of the window.…There's Server Explorer.…
By default, you don't see the SQL Server Object Explorer.…To show that I'll go to the View menu…and choose SQL Server Object Explorer from this menu.…At the moment, they're both sharing…the same space on the left side of the screen,…so in order to see the two of them side by side,…I can't, because they're a tab.…There is a trick you can do in Visual Studio.…You can right-click on this tab and choose…
Author
Walt Ritscher
Updated
8/30/2017Released
8/26/2016- 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
Duration
Views
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.
-
Introduction
-
Welcome1m 2s
-
Welcome1m
-
Install the SSDT features2m 13s
-
-
1. Database and Data Integration
-
The Azure data sources2m 35s
-
2. SQL Server Express LocalDB
-
3. Server Explorer
-
Manage connections2m 3s
-
Add a project level database1m 33s
-
Work with database tables3m 26s
-
4. SQL Server Object Explorer
-
Tour the Table Designer2m 24s
-
Add field to table2m 44s
-
Understand the Power Buffer3m 57s
-
Add or modify table data2m 30s
-
Add and remove tables4m 44s
-
5. Queries, Views, and Stored Procedures
-
Use the Query window5m 53s
-
Work with existing Views3m 33s
-
Create a custom View1m 40s
-
6. Compare databases
-
Data comparison5m 1s
-
Schema comparison5m 21s
-
7. SQL Server Data Project
-
Create a data project2m 4s
-
Add items to project3m 14s
-
Import an existing database2m 38s
-
Build the project2m 54s
-
The sandboxed debug database3m 48s
-
Refactor a database object3m 13s
-
Work with source control2m 24s
-
8. Azure Data
-
Get an Azure account1m 10s
-
-
9. Entity Framework
-
What is Entity Framework?3m 20s
-
Explore the EDM5m 7s
-
Use the Table Mapping window4m 27s
-
Use the Model Browser window2m 16s
-
Modify the EDM3m 13s
-
Use LINQ to query the EDM5m 10s
-
-
Conclusion
-
Next steps53s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: Compare the Server Explorer and SQL Server Object Explorer windows