Custom Actions during compile

[PeterS]

Is it possible to make custom actions that are executed during/before building a package?

More specifically I would like to regenerate some SQL scripts before each build for inclusion in the package.

Regards,
/PeterS

[gigi]

Hi PeterS,

More specifically I would like to regenerate some SQL scripts before each build for inclusion in the package.

You can create an ANT script that regenerate those SQL scripts and use a "Synchronized Folder" (synchronized with the folder where the SQL scripts are generated) in Advanced Installer. For more details about synchronized folders please see:
http://www.advancedinstaller.com/user-g ... lders.html

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com

[PeterS]

Thank you for the quick answer.

So I would have to do that outside the installation build?

Is there any way to communicate custom properties and values to the install from the commandline or any other way?



What I would like to do is,

1. During build extract scripts from an SQL server to be included in the install
2. During install prompt the user for att server to use (preferably with the ADO connectionstring builder wizard) and run the extracted scripts against that server.

[gigi]

Hi,

During build extract scripts from an SQL server to be included in the install

This is not currently supported but we have it on our TODO list and will be available in a future version of Advanced Installer. Until then you need to manually export the scripts from you SQL Server.

During install prompt the user for att server to use (preferably with the ADO connectionstring builder wizard) and run the extracted scripts against that server.

Running SQL Scripts is supported by Advanced Installer. Once you have added the scripts in AI any external modification in the script is reflected in Advanced Installer. For more details about SQL Scripts please see:
http://www.advancedinstaller.com/user-guide/sql.html

Also we have a tutorial about how to use SQL Scripts in Advanced Installer, please see:
http://www.advancedinstaller.com/user-g ... l-sql.html

Kind Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com

[PeterS]

Thank you,

I will look at your guides and do some more testing after the holiday vacation.

I have already done the SQL extraction as a plugin for another installer and was hoping to do that part in a similar way with AI.

Since we are still evaluating wich installer suit us best and I just recently found AI I decided to try it out to.
It has the advantage of being able to create 'clean' MSI files wich I think would be a plus with the IT department.

Regards,
Peter