The SQL Server Data Tools are designed to work with SQL database where ever they are deployed. This video looks at how to manage database items in an Azure SQL database with the SSDT.
- [Voiceover] When it comes time to edit…the adage in the database…use the same tools that you use for any other…SQL server database.…Go to your database over here in SQL Server Object Explorer.…I'm connected to my server on Azure.…Find the table that I want to edit,…add a new field, and then when I'm ready to…change the information to update the Azure Instance…I can click on this Update button.…Tells me what I'm gonna do, then I click on the…Update Database and it'll send the changes to…the Azure server.…
That's good and that works, but let's think about…what I'm doing in this project so I'll cancel…out of here and close this window…and not save the changes.…I'm inside a data project and that's our master…schema for all of our databases whether it's a local…developer Instance or Azure Instance…or a production server so I shouldn't be…changing the schema directly in the database…although you can.…So I got two points here.…If you want to, you can directly change it to the…Azure database or if you're using a data project,…
- 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.