0

Currently our project has one common DACPAC, due to this, when any new projects are being developed, the SQL components are deployed much before the actual release of the project.

Basically DACPAC usually deploys whole Data Base. I need to see if there is any exception I can set which help us in not deploying certain tables, SP, Function or views.

Missy SD
  • 1

1 Answers1

0

You can use sqlPackage.exe to restrict the changes by specifying the types you don’t want to deploy with the parameter /p:ExcludeObjectTypes. e.g.

/p:ExcludeObjectTypes="StoredProcedures;ScalarValuedFunctions;TableValuedFunctions"

to exclude stored procedures, scalar-valued functions, and table-valued functions from being deployed.

Alternatively, you can use the /p:ExcludeObjectFromChangeScript parameter to exclude specific objects from the deployment script and customize the deployment process by avoiding deploying unnecessary components.

sqlpackage.exe /Action:Publish /SourceFile:MyDatabase.dacpac 
               /TargetDatabaseName:MyDatabase 
               /p:ExcludeObjectFromChangeScript=MyStoredProcedure

nb: line break for readability only

see:

Paul Maxwell
  • 33,002
  • 3
  • 32
  • 51