Hi Team,
basically i have installer seup toupdate the product patch.in that i need to execute the scripts mapped in custom sql connection for multiple database.but the database connection string is reterived from the custom action.so how to pass the connection string to sql excution stage and execute the scripts.but this need to be looped in the custom action(vbs). so can you suggest the idea...ASAP
Suggested Articles
Re: Multiple Database script execution
Hello,
To do so you should just make use of installer properties. For instance, you could set within your VBS scripts some properties (e.g. SERVER_PROP) whose formatted references (e.g. [SERVER_PROP]) you can use in the connection fields of your SQL Connection within "SQL Databases" page.
All the best,
Daniel
To do so you should just make use of installer properties. For instance, you could set within your VBS scripts some properties (e.g. SERVER_PROP) whose formatted references (e.g. [SERVER_PROP]) you can use in the connection fields of your SQL Connection within "SQL Databases" page.
All the best,
Daniel