I have a SQL script that needs to get run prior to the main installation kicking off because there is another custom action that depends on the tables being changed. It didn't appear that I could do this by just running the script via the SQL mechanism because you can't run a script, then do something else, then run the rest of them. To accomplish this, I created SQL query (even though I'm not returning data) and run the script via a Custom Action. The script appears to run (no errors) but no changes are made to the tables. If you run something as a query, are commands that alter the table ignored?
To work around this, I just run the SQL script via command line with sqlcmd.exe and that seems to work.
FOLLOW US
Get the latest news in Application Packaging