'How to execute a data script from inside of a .dacpac file (SSDT project) using powershell or any other tool?
When I publish an SSDT project, as shown in the attached image, it generates the .dacpac file. From that .dacpac file, I want to execute a specific script after publishing the .dacpac. Is it possible to do so? I mean is it even possible to access that individual script file? If so, what is the way and which tool/command should I use in PowerShell?
PS: I know how to execute a .dacpac file against a database using a "SqlPackage.exe" and a "publish profile". I want to know a way to execute just an individual script, neither the tables nor the sprocs. Everything else works fine.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|