Tags » SSDT

The Alternative to Pre-Model Scripts


Two of my most recent posts have concerned pre-model scripts; those scripts that need to be run before the dacpac is compared against the production database. 467 more words

Database Development

SSDT and Pre-Model Scripts


Earlier this week I posted about the need to create the database as a pre-model tasks: that is creating a database before we run sqlpackage/dacfx against a database/server so that the script itself does not create the database. 423 more words


Where Will SSDT Create my Database

SSDT is great for many things, but one thing it’s not great at is giving control over to the user with regards to data and log file creation. 659 more words

SQL Server

Speaking about DACPAC Deployments at the St.Louis Dev up Conference, Oct 21st 2016

The world of SQL Server Development has seen great improvements with the introduction of SQL Server Data Tools (SSDT), which allows you to generate the DACPAC Deployment artifact. 126 more words

Sanil Mhatre

Build a testing database with SSDT and NuGet

tldr; My central idea was to use SSDT to build a dacpac file that would define the schema of our testing database and wrap that DACPAC artifact in a nuget package that testing projects could reference.

3,223 more words

SSDT Build Action (AHA!)

One feature I really enjoy in SQL Server Data Tools (SSDT) for database development is the ability to include scripts in the project that are not used in the build process.   332 more words

SQL Server Data Tools

Deploying SSDT Scripts (With My Good Eye Closed)

(If anyone actually gets the reference: kudos. If not, then it’s just that you’re not a Soundgarden fan)

So, there’s something that has been troubling me about deploying to databases with SSDT for some time. 948 more words

Unknown Unknowns