O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

There's more...

Usually, SSDT database projects only create empty database shells when we select the option that always recreates the database. The reason why we have data in the newly deployed database is because we added a script to the database project, as shown in the following screenshot (AdventureWorksLTData.sql):

This file contains INSERT statements that load the different tables. You can glimpse its content in the following screenshot:

This SQL file is called via a special script in SSDT: a post deployment script. To create it, we simply ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required