We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

brendan.hill
Posts: 4
Joined: Thu Mar 07, 2013 7:21 am

SQL script deployment

We're considering purchasing Advanced Installer to deploy a .NET / SQL application & updates.

How clever is the SQL script deployment? OUr ideal setup is:

1) Trigger scripts to be run at the start of the installation package

2) Dynamically determine which scripts need to run based on versioning data within the database

3) Rollback all scripts & halt software installation if any error occurs

4) Trigger a database backup before any scripts are run

If Advanced Installer can't do all these things, I assume it is able to trigger a custom .NET DLL we create, then halt it's own execution depending on the response code?

Regards,
-Brendan
brendan.hill
Posts: 4
Joined: Thu Mar 07, 2013 7:21 am

Re: SQL script deployment

FYI, found the answers I needed in these two links:

http://www.advancedinstaller.com/user-g ... ripts.html

http://www.advancedinstaller.com/user-g ... t-sql.html

It looks like for our purposes the built in functionality might not be quite enough. Therefore we're more likely to go with a Custom Action triggering a custom built or third party .NET tool.

Return to “Building Installers”