I have a package with a power shell script which executes the database.exe. On deploying it via a polling tentacle on my local machine, the script successfully executes. As per the log all the database scripts are executed on my SQL Server localdb. But, I do not see any changes that got reflected on my localdb. I confirmed that the package has been deployed to my local machine. If i manually run the script from the deployed package the database changes reflect. But when octopus runs the powershell the database changes does not happen but the log captures that database upgrade has been completed successfully.
Please let me know if you need more information on this issue.