How to deploy Flyway Desktop in MECM/SCCM Configuration Manager

dontflyway

Please help me deploy this wonderful tool to admins using MECM/SCCM.

So far... I've been able to find 2 ways of deploying it. Both methods have not worked for me.

For Method #1, where do I add the license to the MST file?
For Method #2, I have not had any luck since it extracts the app.

Method #1 - MSI with Transforms MST file

msiexec /i "\\file01\MEM Storage\Software\Production\Flyway Desktop 7.3.8.0\Flyway Desktop_7.3.8.0_x64.msi" TRANSFORMS="\\file01\MEM Storage\Software\Production\Flyway Desktop 7.3.8.0\Flyway Desktop_7.3.8.0_x64.mst"

MSI: {76922851-2B44-4808-8B4C-7E70E1E338BB}

Method #2 - EXE Command Line (directly 

Flyway_Desktop.exe /IAgreetoTheEULA RG_LICENSE=123-456-123456-0DBA

cperez

Good Day dontflyway,

Thanks for reaching out to Redgate Support regarding your questions on extracting and installing from an MSI File. I am going to include our documentation on how to extract the installer for our products, but with respect to passing the license key, you should be able to install the product first and then within the application pass your License Key by selecting the cogwheel > licensing where it will direct you to a login to confirm your Key. If you are only working from the CLI, you can pass a Flyway -auth -IAgreetoTheEULA command and pass your License Key this way as well.

https://documentation.red-gate.com/in/extracting-and-installing-from-the-msi-file

https://learn.microsoft.com/en-us/windows/win32/msi/command-line-options?redirectedfrom=MSDN

Let me know if this doesnt work for you for some reason.

dontflyway

Thank you for the response cperez. I appreciate the official documentation and Microsoft command line options for MSI files.

However, the issue here is not deploying an MSI file but rather how to add the license to the MSI File, or how to install using .EXE with the license file explicitly added. When we deploy an app, we don't want users to manually add the license file.

The documentation you provided shows how to extract an MSI and perform the installation with the following commands:

Extract MSI file from .EXE
C:\Downloads>Flyway.exe extract "C:\Flyway Installer\"

Install MSI file with Transforms (.MST)
msiexec /i "C:\Redgate installers\SQL Compare 10.3.8.406\SQLCompare_10.3.8.406.msi" TRANSFORMS="C:\Redgate installers\SQL Compare 10.3.8.406\SQLCompare_10.3.8.406.mst" ADDLOCAL=ALL

I am not working from the CLI, we are using modern enterprise deployment tools and as such, can you please indicate where in the MSI transforms file am I supposed to add the license?

cperez

Thanks dontflyway,

You would install the product first, and then once the product is installed, you will pass the license key directly in the application. Inside of Flyway Desktop there is a licensing sign in option where you can pass your license key to authenticate, I do not believe there is a manner to pass your license directly in the MSI Transforms file.

Best Regards,

Christian Perez

dontflyway

Okay thank you for confirming.

Can you tell me if this will work for Flyway Desktop installations using EXE file by adding the license details after RG_LICENSE within the command line shown below?

I found this command here: Installing/Activating SQL Prompt from the .msi File – Support (red-gate.com)

Method #2 - EXE Command Line (directly 

Flyway_Desktop.exe /IAgreetoTheEULA RG_LICENSE=123-456-123456-0DBA

cperez

Apologies on the delay,

I checked with my colleagues on this today to be sure and you are welcome to try, but we are not aware of a way to pass the RG_License programatically using the EXE file, however we have not tested this so if you do get this working, please let us know and I can get it documented.

Best,

Christian Perez