Level: Introductory to Intermediate
Come see how to simplify your database tasks with the SSDT.
This session covers the data tools available for developers within Visual Studio, called the SQL Server Data Tools (SSDT). There are several tools, options, and features that comprise the SSDT. The SQL Server Object Explorer in Visual Studio is a mini-SQL Server Management Studio. So you can now do most everything you need to do using one tool.
The Database project allows you to check in/out your database table, stored procedure, and data scripts. Compiling a Database project produces a DACPAC that you, your DBA, or a sys admin can use to deploy database changes. No need to ever write a change script again!
Come see how to simplify your database tasks with the SSDT.
You will learn:
- How to use the SQL Server Object Explorer within Visual Studio
- How to build a database project
- How to deploy database changes using a DACPAC