It is possible to configure Dbvisit Replicate in such a way that you can keep away APPLY process from target server where MSSQL database is running. APPLY process communicates with MSSQL database through DSN therefore to offload APPLY to another server, we need to configure DSN on that server.