CODEWITHSUNDEEP
sql-serversql-server-data-toolsdacpac
user8179431
user8179431

Reputation:

SQL Server Database Project

I want to use database project for script deployment in Azure SQL Server, I don't want to import full database. I just want to use database project for delta script. I added a project and included one script file with none as build action that contains create table statement , I am publishing the project, It's completing successfully but create statement is not executing. What is wrong here? Is there any other way to do this?

Upvotes: 0

Views: 136

Answers (1)

Ed Elliott
Ed Elliott

Reputation: 6856

TLDR: Set your build action to "Post Deployment Script".

Longer:

What happens in SSDT is that all the files that have a build action of "Build" are built into a model of what the database should look like. When the deploy happens that model is compared to the target database and if there are any changes, a change script it generated and then optionally deployed.

If you have any file marked pre or post deployment script then they are either prepended or appended to the change script and will be run as part of the deployment.

If you have any files with a build action of "None" then SSDT ignores them, you could put anything in there, even an ascii picture of a donkey and the project will still build and deploy (obviously your ascii donkey won't get deployed anywhere).

If you just want to use SSDT to do your deployments you can just set the build action to pre or post deploy and it will be included. This is pretty odd though, either don't use SSDT or use SSDT and put the model of your entire database in there.

Personally, I would use SSDT properly and live the dream.

Ed

Upvotes: 2

Related Questions