Table of Contents

Search

  1. Preface
  2. Data Replication Overview
  3. Understanding Data Replication
  4. Sources - Preparation and Replication Considerations
  5. Targets - Preparation and Replication Considerations
  6. Starting the Server Manager
  7. Getting Started with the Data Replication Console
  8. Defining and Managing Server Manager Main Servers and Subservers
  9. Creating and Managing User Accounts
  10. Creating and Managing Connections
  11. Creating Replication Configurations
  12. Materializing Targets with InitialSync
  13. Scheduling and Running Replication Tasks
  14. Implementing Advanced Replication Topologies
  15. Monitoring Data Replication
  16. Managing Replication Configurations
  17. Handling Replication Environment Changes and Failures
  18. Troubleshooting
  19. Data Replication Files and Subdirectories
  20. Data Replication Runtime Parameters
  21. Command Line Parameters for Data Replication Components
  22. Updating Configurations in the Replication Configuration CLI
  23. DDL Statements for Manually Creating Recovery Tables
  24. Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
  25. Glossary

Configuring an Environment Variables List for the Main Server

Configuring an Environment Variables List for the Main Server

By default, Data Replication uses the system environment variables for all servers. You can optionally add a custom environment variables list to use with a particular Server Manager Main server and replication configuration.
To view the system environment variables from the
Server Manager
tab >
Servers
view , click the
System Environment
icon button on the Server Managers toolbar.
  1. To add a custom environment variables list, click the
    Server Manager
    tab >
    Environment
    view.
  2. Click
    Custom Environment
    .
  3. In the
    Custom Environment Editor
    dialog box, click
    New
    .
  4. In the
    New
    dialog box, enter a name and owner for the environment variables list and click
    OK
    .
    The names of environment variables lists can contain the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character. The Data Replication Console truncates list names that are longer than 100 characters.
    Only the owner of the custom environment variables list can edit it later.
  5. Click
    Close
    .
    The
    Server Manager
    tab >
    Environment
    view is displayed again.
  6. In the
    Environment Lists
    list, select the name of the new environment variables list. Also verify that the correct Main server is selected.
  7. To add an environment variable to the list, click the
    New
    icon button on the Server Managers toolbar.
  8. In the
    New
    dialog box, enter the environment variable name and value. Then click
    OK
    .
    Environment variable names can contain the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character. The Data Replication Console truncates environment variable names that are longer than 100 characters.
    The environment variable appears in the variables list box.
    The following image shows a list with one environment variable:
    Environment variable list with one custom environment variable defined.
    Repeat steps 7 and 8 to add more environment variables to the list.
  9. To assign the custom environment variables list to a specific configuration and Server Manager Main server, perform the following substeps:
    1. Click the
      Configs
      view.
    2. Select a configuration and click the
      Properties
      icon button.
    3. In the
      Runtime environment
      list for the source or target Server Manager, select the environment variables list.
    At run time, Data Replication uses the environment variables that are defined in the list for replication jobs that use the configuration.

0 COMMENTS

We’d like to hear from you!