SQL Server Data Tools (SSDT) includes a Schema Compare utility that you can use to compare two database definitions. When differences exist you can you can update the target database. This tutorial looks at how to use the comparison tool to compare the SQL Server Data project files against live instances of a database.
- [Voiceover] In this database project I've been…making changes to the scheme in my SQL files.…At some point I'd compare my current scheme against some of…our other databases in our network.…I've used the schema compare tool and the data compare tool…in other movies, let me refresh your memory.…You can go to a SQL instance like this one here…right-click on it and choose schema compare or data compare.…When you choose the schema compare…you choose from this drop-down, it's already selected that…local instance using a database, we'll click on okay.…
And then I would pick a target here,…and then I would go out and choose another database.…Now when I click the compare button it will check the…schemas in these two live databases…and tell what me the difference is.…If I wanted to do that in this project…and wanted to use a database connection,…I'd have to use the debug database to do that.…I've talked about the debug database in this chapter…but it's over here, it's in this projects V13 folder.…This is the database that gets created…
- 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.