Do you work with a database as part of your development tasks? This course covers the data tools available for developers within Visual Studio. These tools, called SQL Server Data Tools (SSDT) allow you to perform database tasks, create and manage database scripts, and easily deploy database changes all from within Visual Studio. Enjoy!
Scripting Data We have seen how to create a database project that includes table and stored procedure scripts. But, what about data? There are often times that you need to pre-populate tables with reference data, such as valid customer types in a customer type table. Welcome to Visual Studio Data Tools for Developers. My name is Deborah Kurata and this module focuses on scripting and publishing data. This module covers creating insert scripts to insert data into a database table, defining a post-deployment script to include the data scripts in the deployment, and using a merge script to better control updating data in a database table. Let's script some data.
Final Words In this age of iterative design and quick sprints, the database often needs to change as quickly as the software. As we have seen in this course, using a database project helps you manage and deploy those changes. There are two additional features of database projects that this course has not yet covered: Refactoring support and unit testing. Welcome to Visual Studio Data Tools for Developers. My name is Deborah Kurata and this module presents some final words on the Visual Studio Data Tools. Refactoring allows you to make more complex changes to a database project script over time, such as changing a column name. Unit testing allows you to write unit tests for your database objects, such as your stored procedures. Let's take a quick look at these two features.