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

Adding a Task

Adding a Task

Before you can schedule a task, you must add it.
Task types include Applier, Copy File, Extractor, External, InitialSync,
Microsoft SQL Server Backup,
and Send File. A task can depend on another task or have no dependencies on other tasks.
  1. Click the
    Server Manager
    tab >
    Tasks
    view.
    The following image shows the
    Tasks
    view:
    Tasks view on the Server Manager tab
  2. Click the
    New
    icon button on the Tasks and Task Dependencies toolbar.
    The
    New
    dialog box appears.
    New dialog box
  3. In the
    Task name
    field, enter a name for the task.
    Task names can contain only the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character. The Data Replication Console truncates task names that are longer than 100 characters.
  4. If you are defining a task that depends on another task, select
    Depends on
    . Then select the task on which the new task depends in the adjacent list.
    If you are defining an independent task, ensure that the
    Depends on
    check box is cleared.
    If dependent tasks require a replication configuration, ensure that the root task on which they depend also requires a configuration. The root task is specified in the
    Tasks and Task Dependencies
    box on the
    Server Manager
    tab >
    Tasks
    view. The Data Replication Console cannot run dependent tasks that require a configuration if the referenced root task does not require a configuration.
  5. In the
    Task type
    list, select the task type. Depending on the selected task type, you might need to enter additional information in the associated fields.
    The following table describes the task types and indicates whether you need to enter values in other associated fields:
    Task Type
    Description and Associated Fields
    Applier
    Runs the Applier on the server that you select from the list.
    Data Replication uses the configuration file to build the Applier command and displays the command in the
    Command
    field.
    Copy File
    Copies files from a source server to a target server.
    In the
    Source folder
    field, enter the path to the folder that contains the file that you want to copy. To browse to the folder, click the
    Browse
    button.
    In the
    Target folder
    field, enter the path to the folder to which to copy the file. To browse to the folder, click the
    Browse
    button.
    In the
    File Mask
    field, optionally enter a file name mask that includes wildcards to copy all of the files that match the mask. For example, if you enter the mask
    *.txt
    , Data Replication copies all text files from the selected source folder to the selected target folder.
    Select the
    Move
    check box to move the files instead of copying them.
    Use this task to transmit backup logs produced by the Microsoft SQL Server Backup tasks between the Server Manager servers.
    The Copy File task checks the copy history of processed files. After you copy a file to a target folder, if you try to copy the same file to the same target folder again, the Copy Task skips the file and does not copy it.
    External
    Runs an external program on the server that you select from the list.
    In the
    Command
    field, specify the command to run the program.
    In the
    Run directory
    field, specify the directory from which to run the command.
    Extractor
    Runs the Extractor on the server that you select from the list.
    Data Replication uses the configuration file to build the Extractor command and displays the command in the
    Command
    field.
    InitialSync
    Runs the InitialSync component on the server that you select from the list.
    Data Replication uses the configuration file to build the InitialSync command and displays the command in the
    Command
    field.
    Microsoft SQL Server Backup
    Produces Microsoft SQL Server backup logs in native format on the specified server. This task is optional.
    Enter the Microsoft SQL Server instance name in the
    SQL Server instance
    field, and enter the database name in the
    SQL Server database
    field.
    In the
    Target folder
    field, specify the name of the directory to which to write the backup files. After adding the Microsoft SQL Server Backup task and including it in a configuration, add this directory on the
    Extract Range
    tab if the directory is not already listed as a backup log file location for the configuration.
    If you run native Microsoft SQL Server replication and Data Replication jobs concurrently, clear the
    Run the sp_repldone procedure
    check box to prevent incomplete data capture by SQL Server.
    Send File
    Transmits the intermediate files between the Extractor and Applier.
  6. In the
    Owner
    list, select a task owner.
  7. Click
    OK
    .
  8. On the
    Server Manager
    tab >
    Schedules
    view, schedule the backup task. See Creating a Schedule from the Server Manager Tab.
    Alternatively, start the task manually. See Starting a Task Manually.

0 COMMENTS

We’d like to hear from you!