Loading
Sql Db Backup
I am wanting to backup a SQL database before I apply the patch sql scripts.

 

As the database information is stored in the registry of the computer that I will be running the installer on. I was thinking that I could do a system search to find the information then assign this to a property value then use this in the SQL Script

 

Is this possible?

  • 0_H Yamanishi (Flexera Software)

    In order to use the value of a Windows Installer property in a SQL script, you need to use the Text Replacement functionality. The following sample SQL script illustrates how you create a database with the name storted in the Windows Installer property named MYDATABASENAME:

     

    CREATE DATABASE &37;database_name%

     

    Add the following entry on the Text Replacement tab for the SQL script.

     

    Find What: %database_name%

     

    Replace With: [MYDATABASENAME]
    Expand Post

Loading
Sql Db Backup