Skip to main content

Add 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 and Using filters.

Adding a replication task includes the following sub-tasks: