Replace Placeholders
      Back to home
      1. biGENIUS-X Help Center
      2. Generators
      3. Replace Placeholders

      Microsoft SQL Server - Replace the placeholders - 1.4

      The Generated Artifacts zip file contains files with placeholders for the target environment parameters.

      You should replace all the placeholders to deploy your Microsoft SQL Server Target System.

      Replace the Placeholders

      A toolkit is provided in the generated artifacts to replace the placeholders.

      It is composed of a Powershell script to execute: replace_placeholders.ps1.

      For executing commands with Powershell later in this article, please use at least version 7 provided by Microsoft. If you would like to install the latest version, please check here.

      The process to follow is:

      • Update the replacement_config.json file with your values:
        • Insert the value to replace into the value node

      If your server name contains a \, please escape it with another \.

      For example, your server name is: "LT-PF1NSQ7L\SQLSRV2017"

      In the placeholder's value, you should put "LT-PF1NSQ7L\\SQLSRV2017"

      The placeholder values for server_name can be empty as it is not mandatory to specify a server name to be able to execute a script. If it is empty, localhost will be used as default for the server_name value.

      • Replace the placeholders in the files:
        • Open Windows Powershell (or equivalent) in the replace_placeholders.ps1 location:
        • Execute the following command :
        • .\replace_placeholders.ps1
        • You should have a similar result:
      • The placeholders were replaced in each concerned file                  
      • You can now use these files and deploy your Target system

      Some parameters can be added to the replace_placeholders.ps1 command.

      All are described and available by executing:

      .\replace_placeholders.ps1 - help

      The -ReplacementConfigPath parameter mainly permits using a replacement_config.json file in another path. It is beneficial when you are in a development mode for your project.

      Example of usage:

      .\replace_placeholders.ps1 -ReplacementConfigPath "C:\TEMP\Replacement config files\replacement_config_MSSQLServer.json"

      IIf you run into any issues, check our FAQs section for Generate Artifacts: