Efficient Script Editing: Master the ‘Script Substitutions’ Pane

Table of Contents

• Introduction
• Registration
• Using Advanced Installer
  • GUI
  • Working with Projects
  • Installer Project
    * Product Information
    * Resources
    * Package Definition
    * Requirements
    * User Interface
    * System Changes
    * Server
    * Internet Information Services Page”)
    * ODBC
    * SQL Databases
    * Database server
    * Predefined SQL Connection
    * Custom SQL Connection
    * SQLite 3 Connection
    * SQL Query Tab
    * SQL Script Tab
    * Script Replacements Tab
    * SQL Script Replacement Dialog
    * SSRS Deployments
    * SQL Operations
    * SharePoint Page
    * Silverlight Page
    * Custom Behavior
  • Patch Project
  • Merge Module Project
  • Updates Configuration Project
  • Windows Store App Project
  • Modification Package Project
  • Optional Package Project
  • Windows Mobile CAB Projects
  • Visual Studio Extension Project
  • Software Installer Wizards - Advanced Installer
  • Visual Studio integration
  • Alternative to AdminStudio/Wise
  • Replace Wise
  • Migrating from Visual Studio Installer
  • Keyboard Shortcuts
  • Shell Integration
  • Command Line
  • Advanced Installer PowerShell Automation Interfaces
• Features and Functionality
• Tutorials
• Samples
• How-tos
• FAQs
• Windows Installer
• Deployment Technologies
• IT Pro
• MSIX
• Video Tutorials
• Advanced Installer Blog
• Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

Script Replacements Tab

This tab enables you to replace certain sections of your script. These replacements can use installer properties and they are executed when the package is built.

Do not use script replacements in large SQL scripts because this will seriously affect the execution time. The workaround is to split the scripts so that replacements are in as few as possible.

Adding a new SQL replacement

Use the [Add… ] button, the “Add…” context menu item or press the Insert key while the list is focused. The SQL Script Replacement Dialog dialog will be displayed allowing you to create a new SQL replacement.

Click here

Editing an SQL replacement

Use the [Edit… ] button, the “Edit…” context menu item or press theSpace key while an element from the list is selected. The SQL Script Replacement Dialog dialog will be displayed allowing you to edit an SQL replacement.

Removing an SQL replacement

Use the [Remove ] button, the “Remove” context menu item or press the Delete key while an element from the list is selected.

Topics

• SQL Script Replacement Dialog
  Add SQL replacements

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Also read: