# Define a replication task

This task guides you through defining a replication task that copies the data from the HR.EMPLOYEES and HR.JOBS tables. It is not mandatory to add a source and a target database prior to this step; you can also do this as part of setting up the replication task.

By default the Oracle database includes the HR schema. You will make a copy of the same tables in your Microsoft SQL Server `tempdb`. The EMPLOYEES and JOBS tables created in Microsoft SQL Server will be identical to the Oracle tables.

For information on how to use Transformations and Filters when creating a replication task, see [Defining transformations for a single table/view](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_transformations.htm) and [Using filters](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_filters.htm).

Defining a replication task includes the following sub-tasks:

* [Add a replication task to the Qlik Replicate console](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Tutorial/AddTasktoConsole_sample.htm)
* [Add the source and target endpoints to the task](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Tutorial/AddDBstoTask_sample.htm)
* [Select tables for the Replication task](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Tutorial/SelTables_sample.htm)