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
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 %database_name%
Add the following entry on the Text Replacement tab for the SQL script.
