You can have APPLY process running on separate server instead of target server where SQL Server database is running. APPLY process communicates with SQL Server database through system DSN therefore to offload APPLY to another server, we need to configure system DSN on that server.
Please follow Dbvisit Replicate configuration examples on following link and do as instructed on the server where you want to run APPLY instead of target system.
| Note |
|---|
Make sure that the network settings are configured correctly (Firewall, tnsping,system DSN). APPLY server must have system DSN connecting target SQL Server database and TNS connecting source Oracle database. |