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 and Using filters.
Defining a replication task includes the following sub-tasks: