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.
Adding a replication task includes the following sub-tasks: