Windows Installer Editor Reference
282
Advanced Installations
Database Name
Enter a name for the database to be created on the destination computer.
Import Data Rows
Mark this to populate the database’s tables with all its current data. This is
unavailable until you mark the Import Tables check box below.
Import Views
Mark this to import the defined views of the database.
Import Procedures
Mark this to import the defined procedures of the database.
Import Tables
Mark this to import blank tables from the database. This does not import the
data (mark Import Data Rows to import data). You can import all tables, only
certain tables, or all tables except certain tables. For the last two options, enter
a list of table names delimited by commas.
Refresh when installation is compiled
Mark this to have the SQL statements regenerated from the actual database
when you compile this installation. This causes the compile to take longer. Do
not edit the SQL statements on the Statements tab, because they will be
overwritten during compile.
Remove this database first
Mark this to delete this database, if it already exists on the SQL Server, before
execution of the SQL statements. If this check box is cleared, and the database
already exists, then any overlapping tables are overwritten on the destination
computer, new tables are added, and non-overlapping tables are left as-is. This
results in a composite database that is mixture of new and old.
5. Click OK.
Note
Error checking or debugging is not available for statements that you type or import.
Make sure the SQL code you enter is well-tested before deployment. If errors occur
during installation, the end user will see SQL error messages.
See also:
Tips for Using the SQL Server Scripts Page
on page 280
Specifying Replacements in SQL Statements
You can specify text strings to be found and replaced within the SQL statements during
installation.
To specify replacements in SQL statements
1. Click the Replacement tab on the SQL Script Details dialog box.
See
Configuring a Microsoft SQL Server During Installation
on page 279.
2. Click Add.
The Add Replacement dialog box appears.
3. Complete the dialog box: