peterk
Posts: 11
Joined: Wed Aug 03, 2022 3:23 pm

Add support for adding SQL Script File to command line interface

Tue Oct 18, 2022 6:32 pm

We have a need where we want to modify the list of SQL scripts that are run as part of the installer. The names of the sql scripts change frequently as they contain versioning information in the title. So we need a way of attaching SQL Script Files to a known database server connection.
AI-SQL-Scripts.png
AI-SQL-Scripts.png (47.83KiB)Viewed 15867 times
So a command like the following to allow for automation:

Code: Select all

advinst.exe /edit "myapp.aip" /AddSQLScriptFile "1.2.3-droptables.sql" -dbserver "SiteConnection"

Liviu
Posts: 1026
Joined: Tue Jul 13, 2021 11:29 am
Contact:  Website

Re: Add support for adding SQL Script File to command line interface

Wed Oct 19, 2022 3:02 pm

Hello,

This is already on our TODO list of improvements. I have increased its priority and hopefully it will be implemented in a future version of Advanced Installer.

As soon as this improvement will be available we will notify you on this forum thread.

Until then, I am afraid the only way is to add the SQL script through our GUI.

I apologize for the inconvenience.

Best regards,
Liviu
________________________________________
Liviu Sandu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Catalin
Posts: 6506
Joined: Wed Jun 13, 2018 7:49 am

Re: Add support for adding SQL Script File to command line interface

Tue Oct 17, 2023 9:41 am

Hello,

This improvement has been added in version 21.1 of Advanced Installer.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Feature Requests”