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

Add support for adding SQL Script File to command line interface

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.83 KiB) Viewed 23655 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: 1085
Joined: Tue Jul 13, 2021 11:29 am
Contact: Website

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

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: 6739
Joined: Wed Jun 13, 2018 7:49 am

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

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”