Silent Install Possible???

jolthoffjolthoff Posts: 7
edited July 30, 2009 8:57AM in SQL Prompt Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • 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 DAnu D Posts: 876 Silver 3
    Brilliant!!
    We are pleased it worked for you!
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • 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 DAnu D Posts: 876 Silver 3
    Thanks Jeff.

    That will be definitely very helpful :) !
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.