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, view the results and update the target from the SSDT interface.
- [Voiceover] SQL server data tools…includes a schema compare utility…that you can use to compare two database definitions.…Here's how to get to that utility.…Pick one of your databases.…I'll choose this Northwindv13 database.…Right-click, and choose schema compare.…In this screen, I get to pick the source database,…and the target database.…In the target, I can choose to pick a project.…I haven't showed you how to do data projects yet,…but you can work with the project.…You can work directly with the database…by choosing a connection,…and you can use something called…a data tier application file.…
I'll choose to select connection from my example.…I've already connected in the past…to this Northwindv13_compare database,…so it's showing up in my recent connections.…If you don't see this, click on browse, then local,…then pick your local named instance,…then choose from this drop-down here,…and pick your database.…Now that I've got the two connections set up,…I click on the compare button.…So what this shows is the things that need to change…
- 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.