Silent Install Possible???

jolthoff

I'm looking to see if anyone can help me install SQL Prompt v3.9 silently? I have tried all the switches I can think of to get this to go, but with no luck. Is there a special switch that I can use to install this silently or quietly?

Any help is greatly appreciated!

Jeff

Anu D

Thanks for your post.

The closest we can get to this is: using the command-line to install each product (to cause the product to activate, supply a custom property called RG_LICENSE setting the product serial number). So, for example:

MSIExec /i "SQL Prompt.msi" RG_LICENSE=000-000-000000-0000

Please follow the below mentioned steps to obtain the MSIs:

1. Run the SQLToolbelt.exe
2. As the installation starts and you receive the first screen then right click in the header panel (in the very, very top left)
3. Click on the 'Locate temporary file' menu- installation's temporary folder pops up
4. Installer extracts all the msi's for all products


Kindly let me know if that helped.

jolthoff

You are a genius! It worked just fine!

I also appreciate the tip for the License Activation! You have no clue how long we've been trying to figure this out for this product!

Thanks a million!
Jeff

Anu D

Brilliant!!
We are pleased it worked for you!

jolthoff

I have also found that on some machines I have needed to specify the custom property of RG_WARNING to supress the warning of MDAC 2.8. I have MDAC 2.8 installed, but for some reason, there are a few machines giving this error.

My install line now looks like this:

MSIExec /i "SQL Prompt.msi" RG_LICENSE=000-000-000000-0000 RG_WARNING=False

I also found the following...
I grabbed the msi from the Temp Files location, and just pulled the "SQL Prompt_3.9.0.43" folder out from that location. It contained another folder called "Red Gate". I found that I needed to create a script to copy this folder and it's contents to C:\Windows\Temp\ for the install to work properly. I have noticed I only needed this to be done if I was upgrading only. Below is a simple vbs script I use to accomplish this:

'On Error Resume Next

Const OverwriteExisting = True
Const DONOTOverwrite = False

Set WshShell = WScript.CreateObject("WScript.Shell")
Set objFSO = CreateObject("Scripting.FileSystemObject")

sTEMPSource = "\\Server\share\RedGate\SQL Prompt_3.9.0.43\*"
sTEMPDest = "C:\Windows\Temp\"


objFSO.CopyFolder sTEMPSource , sTEMPDest , OverwriteExisting

Hope this helps everyone else out!
Thanks again
Jeff

Anu D

Thanks Jeff.

That will be definitely very helpful !