Is this flow possible with Advanced Installer

[narramadan]

First let me apologize myself as I am posting out the question with out actually trying this in Advanced Installer. Wanted to know if the below steps are possible or not before I can start .

Below are step-by-step process what we want to accomplish
1. Have a installer, which could copy Java, mysql to some custom location and our product files to C: Drive.
2. Before final completion process of the installation, We want to start mysql invoking a batch file and execute an SQL file. If all the SQL's execute successfully, than we wanna proceed to the Installation Completed screen.
3. Later when we send a Patch/Update, during installation we want our product service to be stopped(if its running) and execute the SQL scripts that are sent by the Patch/Update. After the SQLs are executed successfully, the patch/update files need to be copied to the product installation folder which resides in C:
4. On Uninstall, we wish to ask the client if he wishes to take a backup of the data from Mysql. If yes, than need to invoke a batch file which does the process to backup crucial data from database, writes to a file in preferred location. After which, the uninstall process need to take place to delete all the files/folders that are installed say java, mysql and product files under C:

The above steps seems to be very much custom, But this is the way we wish to have instead of our product taking care of executing the SQL files after installation and up-gradation.

Can these steps be accomplished within Advanced Installer ?

Thanks for taking time to read this.

Madan Narra

[GabrielBarbu]

Hello Madan,

All these steps are possible.You can search both our comprehensive user guide and our forums for information on how to achieve this.
They contain information on how to make updates, use prerequisites (installing third party apps like java and mysql), use custom actions (for running batch files and other programs), create sql connections and run scripts, editing dialogs (for creating custom user interfaces in an Enterprise project), these are all treated in our guide and on the forums.

I highly suggest you also follow all our tutorials in our guide, they contain very useful information for creating your installer, and cover various topics and subjects you will need to be familiar with in order to create your installer in a professional manner.

Should you encounter any difficulties not covered by the two information sources, please feel free to post your issue here and I will gladly assist you to the best of my ability.

Best regards,
Gabriel

[narramadan]

Sure, will go through the docs and see if i can implement the way i assumed to be.

Thanks,
Madan Narra