Expanded
Visual Studio Data Tools for Developers
This course covers the data tools available for developers within Visual Studio.
Course info
Rating
Level
Intermediate
Updated
Feb 12, 2014
Duration
3h 17m
Table of contents
Introduction
Managing SQL Server Objects from Visual Studio
Introduction
3m
Connecting and Exploring
7m
Databases and Tables
13m
Stored Procedures
13m
Data
4m
Summary
1m
Managing Scripts with a Database Project
Introduction
6m
Creating a Database Project
5m
Importing a Database
5m
Editing Scripts
7m
Setting Project Settings
6m
Summary
1m
Publishing Database Scripts
Introduction
8m
Publishing to a Connected Database
7m
Using a Publish Profile
7m
Creating a New Database
3m
What is a DACPAC?
6m
Deploying with a DACPAC
10m
Summary
3m
Scripting Data
Introduction
1m
Creating Insert Scripts
7m
Defining a Post-Deployment Script
10m
Using Merge Scripts
10m
Summary
2m
Working with the SQL Menu Options
Final Words
Description
Course info
Rating
Level
Intermediate
Updated
Feb 12, 2014
Duration
3h 17m
Description
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!
About the author