cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
proactis
Level 4

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?
Labels (1)
0 Kudos
1 Reply
hidenori
Level 17

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.
Find What: %database_name%
Replace With: [MYDATABASENAME]
0 Kudos