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.
