SQL Server Data Tools (SSDT) SQL Project Tutorial


By:   |   Updated: 2014-08-06   |   Comments   |   Related: More > Application Development


Read the tutorial!

One of the more difficult jobs that database professionals have to endure is maintaining installation and upgrade scripts for their databases from release to release. Many methods and tools are used such as loose SQL scripts run via SQLCMD or even writing a homegrown system to handle the creating and upgrading of databases. The biggest headaches are making sure dependencies among objects are observed so an install or upgrade does not fail and also to create scripts to update a database from a previous schema version to the latest. These processes are usually manual and they can be labor intensive. Unfortunately, this also means that they can be prone to error.

In this tutorial, we will examine the following steps in creating a SSDT SQL Project:

  • Creating A New SSDT SQL Project
  • Adding Tables To A SSDT SQL Project
  • Adding Additional Objects To A SSDT SQL Project
  • Working With Post Deployment Scripts
  • Building and Publishing a Database
  • Examining Generated Publish files
  • Setting Publish Properties
  • Refactoring A Database

Read the tutorial!



Last Updated: 2014-08-06


get scripts

next tip button



About the author
MSSQLTips author Armando Prato Armando Prato has close to 30 years of industry experience and has been working with SQL Server since version 6.5.

View all my tips





Comments For This Article





download





Recommended Reading

Data Entry for SQL Server - building quick, efficient data input forms using InfoPath

How to Get Started with SQL Server and .NET

Querying SQL Server Tables from .NET

Working with SQL Server Stored Procedures and .NET

.NET Exception Handling for Database Calls to SQL Server with Try, Catch and Finally














get free sql tips
agree to terms